Red Gate forums :: View topic - determining/choosing specific changes
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

determining/choosing specific changes

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



Joined: 30 Mar 2009
Posts: 19

PostPosted: Wed Apr 08, 2009 4:13 pm    Post subject: determining/choosing specific changes Reply with quote

I'm trying to create a package where just one change should be run (Package an upgrade to a database) but the program SQL Package, even checking just 1 item, create this script for other objects (procedures, views).

How to determine which scripts are only for the package ?

Like: http://www.legalsistemas.com.br/script.doc

Regards
_________________
Att
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6677

PostPosted: Sun Apr 12, 2009 9:22 pm    Post subject: Reply with quote

Hi,

SQL Packager will automatically script objects that the object you want to migrate depend on. This is a good thing,really, and should prevent errors when running the script. There is an option in packager to set whether or not you want to include dependencies.
Back to top
View user's profile Send private message
nnodari



Joined: 30 Mar 2009
Posts: 19

PostPosted: Wed Apr 15, 2009 7:39 pm    Post subject: Reply with quote

I dont have an option like "include dependencies" or something in Schema Options.

Where i find it ? my SQL Package version: 6.0.0.107

Regards!
Nilton Nodari
_________________
Att
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6677

PostPosted: Thu Apr 16, 2009 9:43 am    Post subject: Reply with quote

Hi Nilton,

Thanks for pointing that out. The last release of Packager is missing the include dependencies option. Please download the latest build and give this a try -- it has the include dependencies option put back in.
ftp://support.red-gate.com/patches/SQL_Packager/SQL%20Packager_6.2.0.1.zip
Back to top
View user's profile Send private message
nnodari



Joined: 30 Mar 2009
Posts: 19

PostPosted: Wed May 20, 2009 6:12 pm    Post subject: Reply with quote

Did not work.
SQL Packager yet informing which all objects has been changed, includind identical tables and others database objects.

Any idea ?
_________________
Att
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6677

PostPosted: Thu May 21, 2009 9:31 am    Post subject: Reply with quote

Hi,

I'm not sure that you are using the right tool -- SQL Packager is for scripting databases and making an executable. It allows you to select all objects for synchronization. If you want to see which schema differences, then SQL Compare is the tool for you.
Back to top
View user's profile Send private message
nnodari



Joined: 30 Mar 2009
Posts: 19

PostPosted: Thu May 21, 2009 3:02 pm    Post subject: Reply with quote

But the screen that shows the database objects (after "compare") indicates that there is a change - ALTER - even without changes to made.

In any case, you are correct.

Thanks !
_________________
Att
Back to top
View user's profile Send private message
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