Comments
Sort by recent activity
Hey Brian,
Thanks for the response.
Here's the /include help section from the SQL Data Compare command line help file version: 5.4.0.64 (accessed with the verbose and HTML options)
/include:<object type>:<regular expression>
Database objects or types to be included.
Includes objects of the specified type whose identifiers match the specified regular expression. Note that /include and /exclude rules are applied in the order they are specified on the command line, or in the XML file containing the argument specification. If an object is matched by both an include and exclude rule then the exclude rule takes precedence. Note also that if an object has been explicitly included in the project file it will be included in the comparison even if no include rule matches it, unless it is excluded by an exclude rule. To include all objects of a type only specify the type (eg /include:View )
Value Alias Description
All - All database objects.
Table - Tables.
View - Views.
The last line specifically states that to include all objects of a certain type, that the you should type </include:table>. What is the correct syntax.
Again, for a small database, listing all tables with includes would probably be fine. For any normal to large sized database, this isn't really a practical thing to do. Also, this creates a large amount of maintenance to have numerous developers remember to add the tables to the file and retest nightly builds, etc. [/b][/i][/quote] / comments
Hey Brian,
Thanks for the response.
Here's the /include help section from the SQL Data Compare command line help file version: 5.4.0.64 (accessed with the verbose and HTML options)
/include:<o...
Hey now! Thanks Brian, sorry I didn't figure that out on my own.
Jon / comments
Hey now! Thanks Brian, sorry I didn't figure that out on my own.
Jon
This is still an issue.............can I please get a response to this? / comments
This is still an issue.............can I please get a response to this?
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