Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a web page with some data about the users. Recently, I made a complete change and start developing a new portal and of course a new DB structure. My question : What is the best way to migrate my data from my old DB to my new DB ? My old DB, and my new DB have similar but different structures, both are in SQL SERVER 2008 R2. Thanks.

share|improve this question
up vote 3 down vote accepted

It depends on how different the various tables are. Without knowing how different the tables are between the databases, I would probably expect a combination of scripts and data compare-import tools such as Red Gate's Data Compare tool.

Using Red Gate's Data Compare, you can work around minor differences in table structures.

For splitting tables or significant changes within a table, you may be better off writing an import script from a local copy of your old database or a live connection to the old database.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.