Posts
Sort by recent activity
Can any of Red Gate's tools help me in this scenario?
Hi Mike
Yes this is possible by using the toolkit and creating you own application.
I will contact you directly with more information.
Regards
Dan
Script data without second database
Hi Steve
When you are using SQL Data Compare unfortunately there is no feature like the "snapshot" available in SQL Compare.
As you have discovered SQL Packager does have this ability. A workaround...
Suggestion: Report Application Name instead of using default
Hi Grant
Thank you for the suggestion. We will be including this in a future release.
We are just about to release a minor update, so this should be included in the following release.
Dan
DBCC TRACEON 3604
Hi
Thanks for letting us know about this problem.
We had already spotted this and have fixed it. The fix will appear in the next minor release of the product which will be released shortly.
Regards...
SQLCompare ... command line util
Hi Alan
The problem appears to be in the syntax that is being used you command.
When you wish to use an instance of SQL Server the command needs to have a back slash rather than a forward slash.
th...
Comparing Users and Roles
When you use SQL Compare to make a comparison of two databases it will initially include all objects contained within the databases.
This is primarily because if items were filtered out dependencie...
problem using COPYTO parameter
There are a couple of items that could cause this.
The first is in the syntax that you are using.
With the COPYTO option you need to use two single quotes rather than a single double quote. This is...
Does SQL Backup Support Fail-over Clusters?
SQL Backup is supported in a SQL Failover Cluster.
To set this up follow the procedure for creating a SQL Failover Cluster and than install SQL Backup on the primary server.
This will install the e...
A comma makes the difference
Joern
The setup you have is correct - "Force table column order to be identical" not checked.
You should be seeing after the analysis that in the top portion of the screen you have a black equals s...
Missing tables to compare
Hi
I need to check a few things with you before I can answer your question.
In SQL Compare, do you have these two options checked:
Ignore constraints and index names
Treat items as case sensitive
H...