| 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 (not available for dmssql.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. |