How do I transfer a SQL 2005 Express database to SQL 2005 Enterprise edition?

The following article explains how to transfer a SQL 2005 Express database to SQL 2005 Enterprise edition. This may be necessary if you created your database using the free version of SQL Express edition and wish to transfer the database to your SQL Enterprise edition database included with your hosting account.

Databases created using SQL 2005 Express edition are not compatible with SQL 2005 Enterprise edition. To transfer the database from one edition to the other, it is necessary to export the Express edition database to a .sql file and then import that file to the Enterprise edition SQL server.

To transfer a SQL 2005 Express database, please follow these steps:

1. Open Management Studio Express on your local machine and browse to the database.
2. Right-click on the database and under Tasks, select Generate Scripts.
3. Ensure the correct database is selected.
4. Check Script all objects in selected database and click Next.
5. Click Next on the Script Options screen to choose the default options.
6. Select Script to file and enter the destination of the file. Unicode should be selected.
7. Click Finish.

Once the .sql file is created, you will need to upload it to your website through FTP and contact support@hostmysite.com to have a technician complete the transfer.