What are the challenges you face when working across database platforms? Take the survey
Options

Compare all but one table with Command line

Hi, we are using an automated data comparison via Command line between Source Control and target database. We now add a table that we want to store in Source Control but we don't want the data to be synchronized.
So I added the switch "/Exclude:table:[ef].[QueryHints]" to the argument list. After that we got the problem that Data Compare didn't synchronized any of the tables. When I deactived the exclude switch the programms synchronized all tables again.
How can I exclude only this single table with command line?

This is the complete argument list:
  "/scripts1:$MyDatabasePath"
 , "/server2:$MyServerInstance "
 , "/database2:$MyDatabase"
 , "/scriptfile:$releaseRolloutPathDataCompare$MyDatabase.sql"          
 , "/include:table,view,schema,storedprocedure,function,userdefinedtype"   
 , "/Synchronize"                                                               
 , "/Include:Identical"                                                     
 , "/Exclude:table:[ef].[QueryHints]"
 , "/Options:Default"

Tagged:

Answers

Sign In or Register to comment.