Web Hosting Resource

This FAQ assumes SQL Server 2005 Express is running on your development server.

If not already installed you will need the Microsoft SQL Server 2005 Express Edition Toolkit:
http://go.microsoft.com/fwlink/?LinkId=65111

The DTS Wizard can be downloaded (SQLServer2005_DTS.msi) from here:
http://www.microsoft.com/downloads/details.aspx

Here is an example of how to Export using your own development MS SQL server:

1] Create your MS SQL database and login using your web hosting control panel.

2] Start the wizard on your local machine:
C:Program FilesMicrosoft SQL Server90DTSBinnDTSWizard.exe

3] Input settings for your local MS SQL server

Select Data Source ‘Microsoft OLE DB Provider for SQL Server’
Server: localhost or your server IP
Login: your local login
Password: your local password
Select database you want to import
Click ‘Next’

4] Input settings for our MS SQL server

Select Data Source ‘Microsoft OLE DB Provider for SQL Server’
Server: mssql.pipeten.co.uk
Use SQL Server Authentication
Login: created in control panel
Password: created in control panel
Select database you want to import to
Click ‘Next’

5] Select ‘Copy objects and data between SQL Server databases’
Click ‘Next’

6] Select all the tables you want to import, typically this will be all, to do this Click ‘Select All’ for tables
Click ‘Next’

7] Select ‘Run immediately’
Click ‘Next’

8] Click ‘Finish’

To export (backup) your database follow the instructions and simply reverse steps 3 and 4.