how to migrate data from test server to production server?


  • what r the steps to follow to migrate data from test server to production server& any pre requisites   for doing this please let me know


    thank you



    Friday, April 09, 2010 7:11 AM


  • Hello Bhargav,

    I suggest a side-by-side approach of migration of the data from test to prod environment. please follow the steps mentioned below.

    1. back up your database on the test server. Check the current size of the database (both data and log file).

    2. Create a database on the prodcution server using the same logical file name (as it was in test envionment) and set the defult size of the data and log file to a little higher than the log and data file size of the test environment. This will save your server resources during the restoration process.

    3. Copy the logins from the test to the production server by using sp_help_revlogin. Check the article here:

    4. restore the database on the production environment from the backup created on the test environment.

    This will complete your migration. Hope this helps.

    SKG: Please Marked as Answered, if it resolves your issue.
    Friday, April 09, 2010 7:52 AM