Rename all Tables in Source of Project Before Doing Compare.
Rob_Nugent
Posts: 1
Hi Everyone,
I have a project where I have had to create a lot of manual keys, exclude fields etc. All works well.
I now want to use the same project to compare to a different database.
However, all table names change according to the same pattern.
So
XXXtable1 becomes YYYtable1
XXXtable2 becomes YYY table2
Can I please get a steer on how best to achieve this.
I note that the SQL Data Compare project files are in xml so a global find and replace might be the best way to go.
Or is there a feature I am unaware of.
Kind regards
Rob
I have a project where I have had to create a lot of manual keys, exclude fields etc. All works well.
I now want to use the same project to compare to a different database.
However, all table names change according to the same pattern.
So
XXXtable1 becomes YYYtable1
XXXtable2 becomes YYY table2
Can I please get a steer on how best to achieve this.
I note that the SQL Data Compare project files are in xml so a global find and replace might be the best way to go.
Or is there a feature I am unaware of.
Kind regards
Rob
Tagged:
Comments
Unfortunately there are no functions within the product to help move these across.
I think the "find-replace" approach you describe should work, just make sure to apply your transformation to both the "UnmapTables" and "MapTables" actions as well as any column actions that specify the table name.
Let us know how you get on.
Redgate Software