Post reply

Moving data from one server to another

  • December 18, 2012 at 12:19 pm

    #271714

    Quick question about moving data from one database table to another. I have one test environment and one production environment. I want to move the content in the tables from the production environment into the same database on the test environment. What is the best way to do this? I dont want to do a restore because i need the stored procedures and everything else to stay intact on the test environment. And if i do an import, it will just add to the existing content, giving me duplicates.

    What is the best practices for this kind of things?

    Note: Im using SQL Server 2005

  • December 18, 2012 at 12:36 pm

    #1569738

    The easiest method is to use the Import Data wizard. Right-click on the database, select Tasks, and the Import Data. There is an option under Mappings to delete existing rows. Then you have the option to save as an SSIS package for future use.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply