Activity overview
Latest activity by oliveramadeo
Hi Robert,
Thank you for responding on my post. [image]
Unfortunately I cannot use the saved project since the servername, databasename, username, password, schema and tables that I am using will all be dynamic. Mapping of schema names will also be dynamic that's why I needed to find out how to do it via command line. This will be used for multiple clients.
Sample Scenarios:
"1st Client"
Source: Target:
client_db1 prod_db
dev.table1 >> schema01.table1
dev.table2 >> schema01.table2
owner mapping:
dev >> schema01
schema01 << dev
"2nd Client"
Source: Target:
client_db2 prod_db
dev.table1 >> schema02.table1
dev.table2 >> schema02.table2
owner mapping:
dev >> schema02
schema02 << dev
"3rd Client"
Source: Target:
client_db3 prod_db
dev.table1 >> schema03.table1
dev.table2 >> schema03.table2
owner mapping:
dev >> schema03
schema03 << dev
Based on the scenarios above, will I be able to use the project file without having to edit it out given that the objects names differ from each source and schema name changes for every new client.
Thanks in advance! [image] / comments
Hi Robert,
Thank you for responding on my post.
Unfortunately I cannot use the saved project since the servername, databasename, username, password, schema and tables that I am using will all be d...
Configure Table Mapping and Owner Mapping via command line
Hi,
I am new to SQL Compare. I'm wondering if there is a way to configure Table Mapping and Owner Mapping using the command line? I want to map the tables from source to target that has different s...