determining/choosing specific changes

Packages and compresses schema and contents of SQL Server databases

Moderators: JonathanWatts, Chris Auckland, David Atkinson, david connell, Anu Deshpande, Michelle Taylor, james.billings, Marianne

determining/choosing specific changes

Postby nnodari » Wed Apr 08, 2009 4:13 pm

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
nnodari
 
Posts: 19
Joined: Mon Mar 30, 2009 9:04 pm

Postby Brian Donahue » Sun Apr 12, 2009 9:22 pm

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.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby nnodari » Wed Apr 15, 2009 7:39 pm

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
nnodari
 
Posts: 19
Joined: Mon Mar 30, 2009 9:04 pm

Postby Brian Donahue » Thu Apr 16, 2009 9:43 am

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_ ... .2.0.1.zip
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby nnodari » Wed May 20, 2009 6:12 pm

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

Any idea ?
Att
nnodari
 
Posts: 19
Joined: Mon Mar 30, 2009 9:04 pm

Postby Brian Donahue » Thu May 21, 2009 9:31 am

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.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby nnodari » Thu May 21, 2009 3:02 pm

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
nnodari
 
Posts: 19
Joined: Mon Mar 30, 2009 9:04 pm


Return to SQL Packager 6

Who is online

Users browsing this forum: No registered users and 1 guest