CODEWITHSUNDEEP
sql-serverdatabasessis
Steve S
Steve S

Reputation: 219

Best Method to transform data between multiple databases

I have a very old system that contains three separate databases. The tables within these databases are organized very poorly and the system is inefficient because of it. Our new system requires the data from the old system to be transformed into one new database that has a different schema.

Question What is the best approach to transform the data between the old system and the new? Also is there a method to synchronize the data so as people still use the old system the new system will be updated. This is my first time doing this, so please bare with my poorly worded question.

We are currently using MSSQL 2008 R2 and the new system is moving to MSSQL 2012.

Upvotes: 0

Views: 1077

Answers (1)

rstokes
rstokes

Reputation: 115

To move the data I would suggest using SSIS. You can build queries that transform the data in the tables to the new tables. If the schema remains the same you could use SQL Server replication to synchronize them: http://msdn.microsoft.com/en-us/library/ms151198.aspx. However, this could lead to some performance issues in practice.

Upvotes: 2

Related Questions