To transfer your local SQL database to a WinHost database, you will need to:
1. Backup your local database with Management Studio
2. Upload the backup of your database with .BAK extension to your web site via ftp
3. Use restore tools in WinHost control panel to restore the backup to your WinHost database
Please use
Microsoft Book Online for the instructions on how to backup your local database or see
this community forum post for instructions.
Important notes: 1) Microsoft SQL databases cannot
be attached or restored to
previous versions of SQL Servers. That means that SQL Server 2008 R2 database can only be attached/restored to R2 (or later), etc.
2) SQL 2000 databases cannot be attached/restored to a SQL 2012 database. If you need to attach/restore a SQL 2000 database to SQL 2012, you will first have to convert the SQL 2000 database to SQL 2005 or later.
3) Restore backup is available on all WinHost plans, but the attach tool is a premium feature that is only available on the WinHost Ultimate plan.
After you have backed up your local database and uploaded the backup
file with .BAK extension to your web site, please follow the
instructions below to restore the backup to your database on the WinHost
SQL Server:
- Upload the backup file with .bak extension you want to restore to your site via ftp
- Log in to the WinHost Control Panel at https://cp.winhost.com
- In the navigation menu click the "Sites" tab
- In "Your Sites" section click "Manage" link next to the site you'd like to manage
- In the "Site Tools" section click on "MS SQL Manager" icon
- Click the "Manage" link next to the database you'd like restore your backup to
- Click the "Restore" button next to the "Tools" label
- Click the "Browse" link next to the "Backup File to Restore" text box and locate your backup file on your site
- When the .bak file is located, click on it and click the "Select" button
- Click the "Restore Backup" button
Article ID: 1049, Created On: 3/30/2012, Modified: 4/2/2012