Posts
Sort by recent activity
Redgate 7.1 for Sql 2005 64-bit
We just received Sql Compare 7.1 and we are also in the the process of moving to 64-bit Sql 2005 servers.
Two questions -
1. Can I use the executable to install your software on either a 32-bit or...
Exclude using wildcards?
Can I use wildcards with /exclude? If so, how? For example, I need to exclude all tables that start with EMT.
Thanks!
Disable Triggers using Command-line
Can we use the option to disable triggers when we use sqldatacompare from the command line? How?
System Objects - Redgate no longer ignores
A developer applied changes to ALL stored procedures under our development database, including the system stored procedures. Now when we use Red-gate to compare that database to production, Red-ga...
Excluding Tables
Our developers want to know if there is a Sql commandline option we can use to exclude their temporary tables when the compare script is created.
Thanks.
Grant Execute Fails
We use Red-gate to deploy Sql 2000 database changes from a Development environment to our other environments, exluding users and roles.
What we have run into is that if a developer is not DBO on th...
Blank lines detected with compare, but not applied
We are using Sqlcompare commandline to create our scripts. We are noticing that Sql Compare produces a huge script when we don't expect to have many or any changes. What we have noticed is that S...
Field Order
We are using Sqlcompare command-line version. It does not appear to modify the order of the fields within a table when the order is changed - is that the normal behavior?
Or is there an option tha...
Warnings and Summary with Commandline?
Is it possible to get the Warnings and/or a Summary with the command-line SqlCompare? They are available in the GUI.
Sqlcompare cmdline - ignore additional&identical?
I am using SqlCompare to compare my database with a snapshot. I want to output the differences to a sql script to apply to the db later, but I want it to ignore Additional and Identical. I will ...