Activity overview
Latest activity by j.salmon
Feature enhancement: Where clause editor max size
Request for a feature enhancement, make the max size for the where clause editor much larger (currently just over 4k chars). I generally have to compare larger sets of data where I'm doing an IN st...
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.
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...
Request for very minor UI changes in data comp + sql comp
Respectfully requesting very minor UI changes in data comp. I use both tools religiously daily for various tasks, and use the keyboard exclusively for saved projects that basically just need to be ...
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...
Questions on how to programmatically sync w/ where clause
Brief background on what I am trying to do:
I need to sync a large database. The large majority of tables are small and can be copied in full (can be done with a batch file). There are about 12 tab...
Question regarding how tables are analyzed in cmd mode
I have a question regarding how tables are analyzed for comparison while running from the command line.
I have a long list of tables to <include>. There are about 12 tables I do not want to process...