Using RedGate to synchronize dictionarty tables
Ishaig
Posts: 2
Hi,
I use the RedGate to create and compare the dictionary tables of the productions environment.
I use the XML files to specify what tables to Sync. This creates a lot of manual maintenance (editing each file separetly). Is there a way to use some kind of INI file instead?
Thanks,
Ishai.
[/list]
I use the RedGate to create and compare the dictionary tables of the productions environment.
I use the XML files to specify what tables to Sync. This creates a lot of manual maintenance (editing each file separetly). Is there a way to use some kind of INI file instead?
Thanks,
Ishai.
[/list] 
Comments
If I understand, you are using the command-line version of SQL Compare to synchronize table schema, and you are using the XML format argfile to specify the tables to compare. This is tricky to maintain, so you want to switch to an INI file format.
This wouldn't be possible in SQL Compare natively, but I'd imagine that you could do something like this in fairly short order using the Toolkit API.
It could also be done using a DOS batch file, provided the .ini file is simply a list of tables in a text document. If you're interested in that, I can see what I can do.