CODEWITHSUNDEEP
sql-serverssis
Fabe
Fabe

Reputation: 1205

Best-Practise to migrate data between 2 different SQL Server Schemas?

Background

We are currently facing a migration between 2 different SQL Server Schemas. Both databases use Entity Framework Code-First in the data access layer, but they are different in terms of structure and data. Following mapping of tables and transformation of data are required. Also different primary keys are a challenge since one database is favoring GUIDs the other database generated integers.

Current Approach

Currently we are evaluating SQL Server Integration Services (SSIS) to extract, map and transform the data. In our experience, designing in SSIS can be quiet laborious and confusing.

1st Question: Tool

Is SSIS the right tool for the job? Should we favor plain SQL or other tools?

2nd Question: Process

Are there any processes or best-practise available (i.e. data checking)? Any course, blog or book recommendations?

Upvotes: 1

Views: 557

Answers (1)

Fabe
Fabe

Reputation: 1205

We ended up using SSIS. In the beginning the learning curve was quiet high, but now we are leveraging the benefits concerning transparency and tool support.

Upvotes: 1

Related Questions