How to Import/Export MSSQL 2000 database?

1) From the Start Menu, select “Programs” -> “Microsoft SQL Server” -> “Import and Export Data” then click “Next.

2)In the “Server” field, type in the Name or IP of the source server (your local machine Ip), choose “Use SQL Server Authentication,” type in your username and password, choose your database from the “Database” field, click “Next”.

3) In the “Server” field, type in the hostname of the remote SQL Server (this is listed in your hosting control panel), choose “Use SQL Server Authentication,” type in your database username and password, choose your database from the “Database” field, click “Next”.

The destination server is ” ”
Database User Name : database user name
Database Password : (which is given you in Helm CP)

« How I can connect to MSSQL 2005 database Server? | “Notice: Undefined index” Error in PHP »