| Author |
Message |
nnodari
Joined: 30 Mar 2009
Posts: 19
|
 Posted: Wed Apr 08, 2009 4:13 pm Post subject: determining/choosing specific changes |
 |
|
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 |
|
 |
Brian Donahue
Joined: 23 Aug 2004
Posts: 6344
Location: Red Gate Software
|
| Posted: Sun Apr 12, 2009 9:22 pm Post subject: |
|
|
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
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
nnodari
Joined: 30 Mar 2009
Posts: 19
|
| Posted: Wed Apr 15, 2009 7:39 pm Post subject: |
|
|
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 |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6344
Location: Red Gate Software
|
| Posted: Thu Apr 16, 2009 9:43 am Post subject: |
|
|
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
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
nnodari
Joined: 30 Mar 2009
Posts: 19
|
| Posted: Wed May 20, 2009 6:12 pm Post subject: |
|
|
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 |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6344
Location: Red Gate Software
|
| Posted: Thu May 21, 2009 9:31 am Post subject: |
|
|
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
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
nnodari
Joined: 30 Mar 2009
Posts: 19
|
| Posted: Thu May 21, 2009 3:02 pm Post subject: |
|
|
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 |
|
|
|
