| Author |
Message |
Duns79
Joined: 19 Oct 2012 Posts: 5
|
Posted: Fri Oct 19, 2012 6:27 am Post subject: Can't exclude dependencies when running from command line |
|
|
I am trying to compare two databases using the following parameters
/Project:SomeProject.scp /ScriptFile:SomeScript.sql /Force /Options:DecryptPost2KEncryptedObjects,IgnoreFillFactor,IgnoreWhiteSpace,IgnoreFileGroups,IgnoreUserProperties,IgnoreWithElementOrder,IgnoreDatabaseAndServerName
but it still includes the dependencies that are picked up when comparing the databases and saving them to the script file.
Even when running with /Options:None I still get the same output.
If I run the same project through the UI I can unselect the Deploy All Dependencies check box and I get the script as I would expect.
Is there any way to do this through the command line?
I am running 10.2.0.1337 of SQL Compare.
Thanks |
|
| Back to top |
|
 |
Brian Donahue
Joined: 23 Aug 2004 Posts: 6341 Location: Red Gate Software
|
Posted: Mon Oct 22, 2012 4:48 pm Post subject: |
|
|
Can you please try this build of SQL Compare?
ftp://support.red-gate.com/patches/SQL_Compare/SQL_Compare_10.2.0.1647.zip
There are some problems with 10.2.0.1337 with regard to the way the command-line processes options. _________________ 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 |
|
 |
Duns79
Joined: 19 Oct 2012 Posts: 5
|
Posted: Mon Oct 22, 2012 11:45 pm Post subject: |
|
|
Hi Brian,
I have loaded that version but it doesn't seem to have made any difference. |
|
| Back to top |
|
 |
Brian Donahue
Joined: 23 Aug 2004 Posts: 6341 Location: Red Gate Software
|
Posted: Tue Oct 23, 2012 9:02 am Post subject: |
|
|
Sorry, there isn't any feedback that the program gives that can help. We'll need the project and the databases to try to reproduce the problem. _________________ 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 |
|
 |
Duns79
Joined: 19 Oct 2012 Posts: 5
|
Posted: Tue Oct 23, 2012 11:34 pm Post subject: |
|
|
| I can create a zip file that contains the two databases and the SQL Compare project file. How should I upload this to you? |
|
| Back to top |
|
 |
Brian Donahue
Joined: 23 Aug 2004 Posts: 6341 Location: Red Gate Software
|
Posted: Wed Oct 24, 2012 10:48 am Post subject: |
|
|
Can you attach what you've got to an email and quote F0065890 in the email subject line?
Thanks! _________________ 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 |
|
 |
Brian Donahue
Joined: 23 Aug 2004 Posts: 6341 Location: Red Gate Software
|
Posted: Fri Oct 26, 2012 10:38 am Post subject: |
|
|
I forgot to give you the address... it's support@red-gate.com. _________________ 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 |
|
 |
Duns79
Joined: 19 Oct 2012 Posts: 5
|
Posted: Wed Oct 31, 2012 11:14 pm Post subject: |
|
|
Brian
I have uploaded the files to the FTP site you provided
Thanks
David |
|
| Back to top |
|
 |
Brian Donahue
Joined: 23 Aug 2004 Posts: 6341 Location: Red Gate Software
|
Posted: Tue Feb 19, 2013 11:15 am Post subject: |
|
|
I've retested this issue and it appears to be fixed in SQL Compare 10.2.6. _________________ 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 |
|
 |
Duns79
Joined: 19 Oct 2012 Posts: 5
|
Posted: Wed Feb 20, 2013 5:30 am Post subject: |
|
|
Hi Brian,
I have retested on version 10.2.6 and the problem now seems to be resolved.
Thanks for following up. |
|
| Back to top |
|
 |
|