Scenario: We have MS SQL 2005 installed on a windows 2003 server with 9GB database. We acquired a new Windows 2012 server and installed MS SQL 2014 on it.
My expertise level: Partial knowledge of SQL server and databases
What I need: I am given a task to migrate the 9GB database (SQL 2005) to a SQL 2014.. DB names and all should be identical to old one..
I would like to know the steps involved from experts, so I can achieve this job w/o any issues.
I am thinking of below steps:
1) Full Backup of 2005 database... 2) Create a new database with same name on the new server 3) Restore the full backup (taken on old server) on the new server 4) Change the compatibility level to suit to the new sql server
pls. let me know if this works or do I need to follow other approach. any queries, pls. feel free to ask.
sql_learner
Aucun commentaire:
Enregistrer un commentaire