Comments
Sort by recent activity
Roger that Eddie. Thanks / comments
Roger that Eddie. Thanks
I was actually using SQL Compare, but the short cuts are the same. Thanks for the list - I did realized they worked there. / comments
I was actually using SQL Compare, but the short cuts are the same. Thanks for the list - I did realized they worked there.
AndrewRMClarke wrote:
C'mon! lets have the feature back in. It really is time to do something nice with snippets.
Ditto - add this back in. / comments
AndrewRMClarke wrote:
C'mon! lets have the feature back in. It really is time to do something nice with snippets.
Ditto - add this back in.
Another GUI request.
When viewing the differences, it would be nice if there were short cut keys for Next difference and Previous difference. Currently, the only way to view the differences is by using the mouse and using the diff buttons.
Thanks! / comments
Another GUI request.
When viewing the differences, it would be nice if there were short cut keys for Next difference and Previous difference. Currently, the only way to view the differences is by u...
In data compare, when using the server registration ALT+T controls to many options (the one to switch to tables and views doesn't work at all from the main 1st tab).
ALT+C copy from the same form does (Data Source tab)? It'll try to copy data to itself [image]
When the user is in the Synch Wizard in either app (with the direction, backup, summary, confirm) popup, I think the following should occur:
1. Escape key in all forms should = cancel (default for most windows apps).
2. Enter should proceed to next part (equiv to Next button).
My 2 cents worth. / comments
In data compare, when using the server registration ALT+T controls to many options (the one to switch to tables and views doesn't work at all from the main 1st tab).
ALT+C copy from the same form d...
Roger that - that would make to much sense :idea: / comments
Roger that - that would make to much sense :idea:
Ok, following your instructions........here's what I did.
I ran the following
sqldatacompare.exe /project:"c:\VinylRemake.sdc" /include:Table:\[VinylRemakeHistory\]
This runs the data compare only for the table VinylRemakeHistory. This runs quickly and outputs the results as expect.
Registering databases
Mapping
Comparing databases
Finished
Summary Information
=====================================================================================================================================================================================================================================
DB1 =
DB2 = alsddb4.aldata002
Object type Name Records DB1 DB2
Table [dbo].[VinylRemakeHistory] 10 >>
Table [dbo].[VinylRemakeHistory] 52960 <<
If I add a sync to the end of the previous cmd:
sqldatacompare.exe /project:"c:\VinylRemake.sdc" /include:Table:\[VinylRemakeHistory\] /sync
The sync. fails. I get the following error:
Error: Synchronization of 'Server1.TestDB1' and 'Server1.TestDB2' failed: The DELETE statement conflicted with the REFERENCE constraint "FK_VinylRemakeHistoryProductionLine_VinylRemakeHistory". The conflict occurred
in database "TestDB2", table "dbo.VinylRemakeHistoryProductionLine", column 'VinylRemakeHistoryID'.
In the project, I have specified for it to drop everything in the sync behavior (foreign keys, prim keys, triggers, etc). If I reopen the .sdc in data compare, the settings are retained, but they don't appear to be used with the command line compare? / comments
Ok, following your instructions........here's what I did.
I ran the following
sqldatacompare.exe /project:"c:\VinylRemake.sdc" /include:Table:\[VinylRemakeHistory\]
This runs the data compare only ...
Hi Robert and thanks for the quick response.
I was unaware about creating and then executing a .sdc file from the command line, so I gave that a shot.
I created a project. I selected only one table (leaving all other tables unchecked). With this one table, there is a where clause which selects rows based on date; in this scenario exactly 10 rows are returned. When running the project through the data compare GUI, the comparison is instantaneous. When running the same query through SQL server manager, the query execution time is 00:00. I saved the project .sdc. My problem is when I run the .sdc through the command line.
I start data compare with this: sqldatacompare.exe /project:"c:\DataCopyTest.sdc" /verbose
Data compare starts, but never finishes. It just sits at "Comparing databases". Am I doing something wrong? I looked at the .sdc file and have verified that no other tables are listed. / comments
Hi Robert and thanks for the quick response.
I was unaware about creating and then executing a .sdc file from the command line, so I gave that a shot.
I created a project. I selected only one table...
I got this handled by using the NoSQLPlumbing option in the argfile. The errors returned by sql compare are a little confusing since it is referencing a linked server on the dest server.
Jon / comments
I got this handled by using the NoSQLPlumbing option in the argfile. The errors returned by sql compare are a little confusing since it is referencing a linked server on the dest server.
Jon
I found in a previous thread that this is not possible. Can this be added as a future feature request? The new feature should take into account the following:
<include>Table</include>
<include>Table:TransferCodes</include>
<comparisonkeys>TransferCodes:TransferCodeID</comparisonkeys>
The comparison can be completed using a column name vs. index. Also, if a specific table + comparison are defined, the specified settings should be used (instead of any default setting created with the <include>Table</include> option).
Jon / comments
I found in a previous thread that this is not possible. Can this be added as a future feature request? The new feature should take into account the following:
<include>Table</include>
<include>Tabl...