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

Rename all Tables in Source of Project Before Doing Compare.

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

Tagged:

Comments

  • Options
    David EDavid E Posts: 75 Silver 1
    edited May 2, 2017 8:50AM
    Hi Rob,

    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.
    Software Engineer
    Redgate Software
Sign In or Register to comment.