|
Subject:
|
??? Uploading database to Web Host's SQL server
|
|
Posted By:
|
Jan_Ma
|
Post Date:
|
6/18/2003 6:55:11 PM
|
I'm a home user with Visual Studio .NET Professional (Academic) 2002 & 2003. I have MSDE installed. Can someone tell me how to transfer my local database with tables and stored procedures to my Web Hosting SQL server?
I can connect to the database my Web Host setup in Visual Studio, but I can't copy and paste my tables and stored procedures. I'm new to this, so if you respond, please deal with me as a relative beginner. Thanks.
|
|
Reply By:
|
Ned
|
Reply Date:
|
6/20/2003 5:01:23 PM
|
Backup your local database which include table and store procedures. This will make a file which you can upload your Web server. There you can restore it in Web SQL server.
-ned
|
|
Reply By:
|
students886
|
Reply Date:
|
11/12/2003 11:25:43 AM
|
some problem about sqladapeter
|
|
Reply By:
|
chrislepingwell
|
Reply Date:
|
11/12/2003 11:27:53 AM
|
Care to give us a little more to go on?
There are two secrets to success in this world:
1. Never tell everything you know
|
|
Reply By:
|
alyeng2000
|
Reply Date:
|
11/14/2003 11:10:51 PM
|
From the older Sqlserver get your Data files (mdf , ldf) and upload them to your new sqlserver using DTS
Ahmed Ali
Software Developer
|
|
Reply By:
|
cs001
|
Reply Date:
|
11/16/2003 10:35:17 PM
|
We do it with DTS (data transformation services) Transfer Databases Task.
In your enterprise manager, create a new dts Package, and look for Transfer Databases Task in the Task tools.
Your Web Hoster's sql server will have to be registerd in your Enterprise Manager (right click on SQL Server Group, New SQL Server Registration).
Good luck
Eric
|
