Posts
Sort by recent activity
SQL Backup Logs and fn_dump_dblog()
We had an incident earlier in the week where data was accidentally deleted from a database and we needed to track down when it happened and who caused it. There are a few undocumented functions for...
SQL Backup 10 GUI/Restore Timeouts
We have been experiencing problems with one of our SQL Backup Pro instances, version 10.0.12. • Trying to do a restore via the GUI is extremely slow and connections in general are slow. • We experi...
Restore DB Works in SQL Pro 7 GUI, Errors TSQL Manually
I am trying to restore about 70 databases individually (to do some synchronizations on a few archive SQL servers) from a backup on SQL Server 2005 to SQL Server 2008 R2. When I try to run the follo...
SQL Scripts and Source Control
We recently purchased some additional RedGate tools, among them is the Source Control product. While we do need to add a "primary" Database to the Source Control paradigm, we really need to be able...
SQL Data Compare 6 versus 8 Command Line Options
I was working on re-setting a weekly database sync job using the SQLDataCompare [version 8] and it appears one of the command line options is no longer valid:
/ignoreadditional (Alias: /a)
Do not c...
Sync Fails due to Primary Key Constraint
I am trying to synchronize two tables in two different databases. The table structures are indentical (primary keys have different names but they use same key fields).
I tried to sync the databases...
Strange Behavior Command Line BATCH file
I have been experiencing a strange problem using the COMMAND LINE and a batch file for the SQL Data Compare, version 6.0.0.1124.
I create a project using the SQL Data Compare GUI, then, in MS Explo...
DB Sync using BATCH file Versus SSIS
Currently, we are using a lot of "command line" data compares/syncs using ".sdc" files. Needless to say, since these are batch files that run weekly, we have quite a few scheduled processes on our ...
Data Compare Project File Name
Is is possible to rename the project files form the currrent "cryptic" form,
C:\Documents and Settings\Administrator.SJC\Local Settings\Application Data\Red Gate\SQL Data Compare 5\INET3218 MSMSQL0...
Speed to Cancel Data Compare
I was doing a compare against two tables, one with 10M records and one with 9M records (the 9M should be all new records compared to the 10M record table). I realized I might be able to speed up th...