Red Gate forums :: View topic - SQL Packager Is Creating an Object Even When I Uncheck It
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Packager 6
SQL Packager 6 forum

SQL Packager Is Creating an Object Even When I Uncheck It

Search in SQL Packager 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Wyatt70



Joined: 29 Jul 2005
Posts: 36
Location: Yonkers, NY

PostPosted: Fri Jan 21, 2011 7:01 pm    Post subject: SQL Packager Is Creating an Object Even When I Uncheck It Reply with quote

I am using version 6.3.1.122 of the product.

I open a new SQL Packager project, and choose the "Package an upgrade to a database" option. After it finishes comparing the databases, I go to the "Specify the database objects whose schema will be packaged" window and review the list of objects. I uncheck certain objects that I do not want to be created and then I click "Next". I click the "Uncheck All" checkbox for "Specify tables whose data will be packaged" and click "Next". Then I review the T-SQL that is generated. The "CREATE" statement for the object is in the script.

This seems like a bug to me, and a pretty serious one at that.
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 691
Location: Cambridge

PostPosted: Mon Jan 24, 2011 11:08 am    Post subject: Reply with quote

Many thanks for your post and apologies for inconvenience caused.

Can you kindly check whether the option 'Including dependencies' is checked?

When this option is selected, SQL Packager checks for object dependencies; if you excluded objects and other objects that you selected are dependent on the excluded objects, the excluded objects are packaged. For example, if you select a stored procedure and it references a table, even if you excluded that table, the table is still packaged.

By default, SQL Packager will include dependencies in the package. Clear the option if you do not want to include the dependencies. Note that clearing this check box may produce unexpected results or the script may fail. Roles and users are always included in the package.

You can find the option by navigating Tools --> SQL Packager Options --> Schema Options --> Behavior --> Include Dependencies.

Kindly uncheck that option and see if that helps, let me know how you get on with it.
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
Wyatt70



Joined: 29 Jul 2005
Posts: 36
Location: Yonkers, NY

PostPosted: Mon Jan 24, 2011 5:21 pm    Post subject: Include Dependencies Reply with quote

Yes, this option was checked. Unchecking it resolved the issue. Thanks.
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 691
Location: Cambridge

PostPosted: Wed Jan 26, 2011 11:26 am    Post subject: Reply with quote

Many thanks for the confirmation.

We are pleased that your issue is resolved.
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group