How to create Database tables in a Remote Server?
-
Hi, I am new web programming , so experts please excuse, I've created a simple web app in asp.net2.0 and sql server2000 .I wish to host this web site, and i payed for the webhosting provider. They send me the credentials like: 1. Host Usr name & passwd 2.Database details(ip address,name,usrname,pwd) But my problem is , that i dont know how to copy my database scheme and data into the providers remote database server.i.e from a local db to remote db. Plz help out !!!!! Thax in Advance ...
-
Hi, I am new web programming , so experts please excuse, I've created a simple web app in asp.net2.0 and sql server2000 .I wish to host this web site, and i payed for the webhosting provider. They send me the credentials like: 1. Host Usr name & passwd 2.Database details(ip address,name,usrname,pwd) But my problem is , that i dont know how to copy my database scheme and data into the providers remote database server.i.e from a local db to remote db. Plz help out !!!!! Thax in Advance ...
use this connection string <appSettings> <add key="ConnectionStringname" value="Data Source=ip address;Database=databasename;uid=username;pwd=password;"/> </appSettings> after that open Enterprise manager open sql server group and then run new database registraion wizard,put ur ip address at server name then run wizard,after completing this wizard,right click on thatgroup which genrated as ipp name,and export ur database on that group. before doing this thing u must have to create a database on ur web server and create a database and give uid and pwd.
-
Hi, I am new web programming , so experts please excuse, I've created a simple web app in asp.net2.0 and sql server2000 .I wish to host this web site, and i payed for the webhosting provider. They send me the credentials like: 1. Host Usr name & passwd 2.Database details(ip address,name,usrname,pwd) But my problem is , that i dont know how to copy my database scheme and data into the providers remote database server.i.e from a local db to remote db. Plz help out !!!!! Thax in Advance ...
-
Register the remote SQL server in your local SQl Server 2000 enterprise manager. Then open your remote database and use DTS export/import wizard to copy data from your local database to remote database.
Thanks a lot for the replies !!! But could guide me through the steps to register remote SQL server Plz help!!
-
Hi, I am new web programming , so experts please excuse, I've created a simple web app in asp.net2.0 and sql server2000 .I wish to host this web site, and i payed for the webhosting provider. They send me the credentials like: 1. Host Usr name & passwd 2.Database details(ip address,name,usrname,pwd) But my problem is , that i dont know how to copy my database scheme and data into the providers remote database server.i.e from a local db to remote db. Plz help out !!!!! Thax in Advance ...