Tool to Migrate Data from Old Model to new Model

Hi,

I have a task to migrate the data from an existing database to a new database. However, the new database has a new model (new model created to improve the database structure). I am looking for a tool that can write SQL scripts to migrate these data into the new database model.

Thank you for you suggestions and answers.

Answers

  • Hi, 

    Thanks for your post. 

    Potentially, SQL Data Compare could work for you. Though you might need to manually map tables in the source and target. If you'd consider that option, get in touch with us on support@red-gate.com and we'll see if we can help you confirm. 

    Kind regards

    Robyn Edwards | Redgate Software
    Have you visited our Help Center?
Sign In or Register to comment.