I have two SQL Server 2008 databases. One is for my old application (full of data) and the other is for a complete re-write of my application.
I want to migrate the data, but I have no idea how to tackle it. Some of the tables have exactly the same structure, but some tables in the new database are composed from columns of multiple tables in the old database.
Is there a way to create such a script/project/application in which I can define the data transformation while also maintain constrains?