asklijo.com

  • Increase font size
  • Default font size
  • Decrease font size
Home Search Engine Optimisation

How to transfer local mssql 2000 database to Server

If you have hosted your website with Adsin Media , you can open your server control panel (HELM), and create your mssql 2000, Create db user name and assign the db user to the Created data base.

Now open your local enterprise manager where you have your data base to move to server

select_enterprisemanager

 

The above picture is for demonstration, you have to select your database

 

dts

Kindly click on next

select_localdb

You can select your local data base to move to server

 

enter_server_addrs

Now this interface to enter your database address and db user name and password

 

 

selecttransaction

Select the third option button , so that all object will be transfered

 

dtsimportexport

No need to make any setting here, you can leave it as default

 

 

finalstage

No need to make any changes here , keep it is as default

 

 

finished 

Just press finish, all tables and views will be transferred to remote database server.

 

 

By

Lijo Peter

For Adsin Technologies Bangalore, India
Corporate web hosting Solutions