Post reply

Migrate databases from SQL 2000/2005/2008 directly to SQL Server 2012/2014

  • July 10, 2015 at 10:18 am

    #305683

    Hello Experts,

    Need your advise about if there are bunch of databases which are in SQL 2000 and I need to migrate them all to SQL 2012/2014, whether any steps are involved?

    Can I not able to directly restore the databases onto the new server, followed by moving jobs, and other stuff?

    Please let me know your advises about the typically steps you are following as a best practice.

    In one of the websites, I found that theysuggested to have a temp copy of sql 2008 and restoring dbs onto there first and then moving onto SQL 2014. But the issue is, the client may not accept / alow ro have that in place due to license issues and other logistical issues!!

    http://sqlmag.com/sql-server-2014/sql-select-steps-migrate-sql-server-2000-sql-server-2014

    Thanks....

    Thanks.

  • July 10, 2015 at 10:57 am

    #1811688

    Using a 2008 Evaluation version would give you 90 days to complete the migration without having to pay a license.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

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

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