Activity overview
Latest activity by jeffm
Match Whole Word / Match Case
I'm not exactly sure what the "Exact match" checkbox is supposed to do, but a "Match Whole Word" option would be very helpful.
Example: A search for "Approved" (excluding quotes) returns objects wi...
Feature Request - Next Match / Previous Match Buttons
Great product!
"Next Match" and "Previous Match" buttons would be nice - similar to what you have in the sql compare tools. If the search returns a proc with 1000 lines of code with a single insta...
Greetings.
I have been trying to get a command line comparison working and I am experiencing the same symptoms reported in this thread.
I am running version 6.1.1.308 and when using the most basic of sdc files, it starts comparing and never comes back. My suspicion is that it is comparing everything.
While it was running, I did sp_who2 on the source and destination servers and see the app running - oddly it was using much more CPU Time than Disk IO. I also see the command line process running on my workstation consuming plenty of local memory and CPU resources.
I didn't get it to work until I added "/include:table:\[table1]".
I thought this was fixed in 6.1.x. Is it possible that it wasn't, or that I have an old dll or something?
Output:
C:\Program Files\Red Gate\SQL Data Compare 6>sqldatacompare /project:"C:\UserDat
aSynch\test2.sdc" /Include:Table:\[Table1]
Red Gate SQL Data Compare Command Line Utility V6.1.1.308
==============================================================================
Copyright c Red Gate Software Ltd 1999-2006
Serial Number:XXX-XXX-XXXXXX-E448
Registering databases
Mapping
Comparing databases
Finished
Summary Information
===============================================================================
DB1 = Server1.DB1
DB2 = Server2.DB2
Object type Name Records DB1 DB2
Table [dbo].[Table1] 1 <> <>
/ comments
Greetings.
I have been trying to get a command line comparison working and I am experiencing the same symptoms reported in this thread.
I am running version 6.1.1.308 and when using the most basic ...
Forgive me (and correct me) if there is a better place to post this, but I have a couple of suggestions/requests:
1) I would like to see a feature that allows me to apply the "where clause" to all of the selected tables in my comparison. This would be very helpful when comparing data across environments for a specific set of data like you might find in an order system. Example: I want to compare/synch all of the data in multiple tables all having to do with a specific OrderID.
2) I would like the ability to script out a GUI configuration into command line syntax or an xml file that can be run from the command line or batch files. This functionality would be very similar to the way SQL Server SMS allows you to script objects, databases, replication etc.
3) I would like the Where clause to be exposed to the command line utility.
Thanks / comments
Forgive me (and correct me) if there is a better place to post this, but I have a couple of suggestions/requests:
1) I would like to see a feature that allows me to apply the "where clause" to all ...