Comments
Sort by recent activity
I have another question on this. There are several tables in the database which don't have a specified PK or index (I dunno, I didn't create the tables).
If I run SQL data compare through the GUI, I can manually map the column and the data copies fine. How can I achieve this using the comparisonkeys from commandline ?
For example, I am trying to copy a table called TransferCodes with these for columns:
TransferCodeID,
Code,
Source,
Dest
TransferCodeId is unique, although it does not contain an index. If I use the following comparison, the comparison fails (because it's the column name vs. index name):
<include>Table:TransferCodes</include>
<comparisonkeys>TransferCodes:TransferCodesID</comparisonkeys>
What is data compare setting differently though the GUI which is not being set through an arg file?
Jon / comments
I have another question on this. There are several tables in the database which don't have a specified PK or index (I dunno, I didn't create the tables).
If I run SQL data compare through the GUI, ...
Hey Brian,
Thanks for the info! / comments
Hey Brian,
Thanks for the info!
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...
Hey Eddy,
I've pretty much figured (or fumbled [image] ) my way through and figured out the GUI pretty well. I have been able to replicate much of what I need to do through code. Thanks for the help.
Jon / comments
Hey Eddy,
I've pretty much figured (or fumbled ) my way through and figured out the GUI pretty well. I have been able to replicate much of what I need to do through code. Thanks for the help.
Jon
Like dpuza, our database has several smaller keys defined.........also like dpuza, I dunno why; but I am stuck with copying it nightly (minus several very large tables).
Given that, is there an option to "ignore comparison key" and just force a copy of the data (if not, I'm requesting it)? I'm going to rebuild the schema and data nightly, so the data should just be copied. Many of these tables contain less that 10 rows. Obviously "ignore comparison key" would normally be very bad for 2 dbs that already exist and have data; but when trying to rebuild a database from scratch, it would be very nice (for people stuck with databases lacking keys, etc in many tables). / comments
Like dpuza, our database has several smaller keys defined.........also like dpuza, I dunno why; but I am stuck with copying it nightly (minus several very large tables).
Given that, is there an opt...
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.
Roger that Eddie. Thanks / comments
Roger that Eddie. Thanks