0

I was wondering if there is a safe/clean and efficient way to transfer data from one MSSQL DB to another on following terms:

  • both DB's have exactly the same structure.

I need to be able to choose from which tables I'll export data, and then drop the data from new new table.

So it would look like this:

  • drop data from beta DB
  • insert data into DB from old DB

Does MSSQL has some sort of import/export wizard or some sort of tool which could help me with this ?

Improve this question
3
  • the better is to write your own script Commented Feb 4, 2017 at 14:18
  • If they are on the same server I suggest INSERT/SELECT statements Commented Feb 4, 2017 at 14:25
  • you can use an ETL tool like Talend. Commented Feb 4, 2017 at 14:27

1 Answer 1

Reset to default
1

There is a built-in wizard for data import/export in Sql Server Management Studio:

  • right click on you DB
  • click "Tasks"
  • select "Import data..." or "Export data..."
  • here you can select a source and a destination for you data transfer operations (for example you can chose SQL Server DBs as source and destination and transfer data from tables in the old DB to the same tables in the new DB), but I think that you'll need to write your own script to drop old data

Here is a screenshot that shows how to open this wizard:

enter image description here

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.