NOTE: This article is written for our Classic Cloud Control Panel. You can access this interface from the New Cloud Control Panel by clicking your username in the upper-right of the control panel and selecting "Classic Cloud Control Panel".
If followed correctly, site impact during the migration process should be minimal. With that said, it is highly suggested to perform this migration at a non-peak time to minimize business impact. Here are some tips for database migration:
ALTER DATABASE [NumXYZ_OldDbName] SET READ_ONLY
ALTER DATABASE [NumXYZ_NewDbName] SET READ_WRITE
1) Create a new MSSQL 2008 database in the Classic Cloud Control Panel under the "Features" tab of the domain your MSSQL2005 database is on.
2) After the database has been created, please view its properties (as shown below) and note the change in the hostname. The information for you database will vary from the image depending on what data center your account is hosted in. Please use this new MSSQL 2008 hostname to update your connection strings.
3) Next use the web based admin tool, MyLittleAdmin, to back up your MSSQL 2005 database. The link for the online tool can be found in your Classic Cloud Control Panel by clicking on the database under the “Features” tab. For this backup please add "mlb" to the end of the URL. It is important to add this to the URL and not to go through the standard MyLittleAdmin link found in your Classic Cloud Control Panel. Using the links instead of adding the “mlb” may cause session issues between the two MyLittleAdmin versions. For example: https://mssqladmin.websitesettings.com/mlb
4) Login to your original MSSQL 2005 source database.
5) Now back up your MSSQL 2005 database use the MyLittleAdmin tool. When the backup has completed click on the file link to save the backup file to your local machine.
6) Log in to the MyLittleAdmin link again using your MSSQL 2008 database and login. Remember the login you use to restore will become the new owner of the database. Choose restore and upload the backup file you just downloaded in Step 5. Proceed with the restore.
7) The restore tool may notify you that the old users have no login mapping on the new SQL 2008 cluster. At this point your new database will be ready. The only access, at this point, is allowed to the owner login that you used to restore the database. If you need to change the owner to another login you created in the Classic Cloud Control Panel or remap users in your database to new logins please refer to the KB article on remapping database users and changing ownership in MSSQL.
© 2011-2013 Rackspace US, Inc.
Except where otherwise noted, content on this site is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License