locked
Migrate an SQL 2008 server to a different 2012 across different domains/forests RRS feed

  • Question

  • Hello all

    We are going to migrate our sql 2008 to a new sql 2012 server. The issue here is that the new machine will be located in a new domain/forest with no trust relationship between the two domains. IP schema and hostname of the server will be different but user logins will remain the same. There is no possibility to have a trust relationship between the 2 forests so creating one is out of the question.

    The question is what is the most proper way to migrate the databases from the old 2008 server to the new server. Will detach/attach work in our case or can we do it in a different way? What are the issues that we might face on this if someone could share its experience on this it will be much help to us.

    Friday, August 16, 2013 7:27 AM

Answers

All replies

  • Hello,

    Backup restore would be best method to transfer data from sql server 2008 to SQl server 2012.detach attach has some ownership problem (sometimes) during restore.

    Regarding users who used domain login(old domain) to access SQl server ,You have to get there account created in New domain.For other users who used SQl authentication it will not make much difference.

    You can transfer logins by script method.

    Your mode of migration should be side by side.Dont decommission your legacy(old sql 2008) till you have done all testing for SQL serevr 2012 ,including application compatibility.

    Please refer few links

    http://blogs.technet.com/b/mdegre/archive/2011/06/27/can-i-move-sql-server-to-another-domain.aspx

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/c1c84ff0-47a7-4ed5-b507-5e3d15914a41/moving-sql-server-between-domains


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    • Proposed as answer by Sofiya Li Monday, August 19, 2013 9:00 AM
    • Marked as answer by Michalis K Monday, August 19, 2013 9:28 AM
    Friday, August 16, 2013 8:41 AM
  • Thanks Shanky for your prompt response on this.

    As you said backup and restore is the best method to use. Is there any document available (official Microsoft document) that highlights in high level the steps to be taken. I mean any pre requicites that we have to check, any known issues etc?

    Friday, August 16, 2013 9:30 AM
  • Thanks Shanky for your prompt response on this.

    As you said backup and restore is the best method to use. Is there any document available (official Microsoft document) that highlights in high level the steps to be taken. I mean any pre requicites that we have to check, any known issues etc?

    Hello Michalis,

    Restore process is same as it will be to any environment.Just take full backup of your database then transaction log backup and restore it on newly installed DB on other domain.Make sure you have proper rights.

    You can use this link to restore from SSMS http://technet.microsoft.com/en-us/library/ms177429.aspx

    For known issues I dont have any document ,you can refer to links provided by me in prev post


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    • Proposed as answer by Sofiya Li Monday, August 19, 2013 9:00 AM
    Friday, August 16, 2013 12:30 PM
  • Hi Michalis,

    In addition, when moving user databases, we can use the other methods.For example, using the sp_detach_db and sp_attach_db stored procedures or the Import and Export Data Wizard to copy objects and data between SQL Server databases.

    As Shanky post,we need to transfer the logins from the source server to the destination server.

    There is more details about moving databases between two server, you can review the article.
    http://support.microsoft.com/kb/314546/en-us

    Thanks,
    Sofiya Li



    Sofiya Li
    TechNet Community Support

    Monday, August 19, 2013 9:54 AM