Wrox Programmer Forums
|
ASP E-commerce As of Oct 5, 2005, this forum is now locked. No posts have been deleted. Please use "Classic ASP Professional" at: http://p2p.wrox.com/forum.asp?FORUM_ID=56 for discussions similar to the old ASP Pro Code Clinic or one of the other many remaining ASP and ASP.NET forums here.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP E-commerce section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 16th, 2003, 02:33 PM
Authorized User
  
Join Date: Jun 2003
Posts: 34
Thanks: 0
Thanked 0 Times in 0 Posts
Default Uploading database tables/stored procedures
In Visual Studio .NET 2002, I can connected to my Web Hosting service's database that they have set up for me for MSSQL.

I tried to transfer the tables and stored procedures I have on my local machine to my database on my Hosting service via Studio IDE. Visual Studio won't let me just copy, and paste.

Also, I do have Visual Studio .NET 2003 installed, but I haven't used it yet because I'm not quite ready to convert my project in 2003 because of some fears of some possible unexpected problems.

Can anyone help me on how to transfer a database to a Web Hosting SQL server? I read about the Copy Database Wizard, but I am running MSDE 2000, and I don't know if I have this wizard to use, or where it would be if I do have it.

Jan_Ma
Contact me at: [email protected]
 
Old July 4th, 2003, 02:09 PM
Authorized User
  
Join Date: Jun 2003
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Default
Do a search on your computer to find the sql server database. It will be called <your_database_name>.mdb. Find out from your Host which folder this should sit in and ftp it.

You may not have access directly to the folder in which case you might have to send it to the host allowing them to copy it to the correct folder.

Regards

Skin





Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't use stored procedures containing temp tables jsandee Reporting Services 1 December 20th, 2007 02:24 PM
Where r database tables get stored ?? kajal SQL Server 2005 1 April 1st, 2007 08:38 AM
Using System Tables, Views and Stored Procedures syphon SQL Server ASP 2 September 6th, 2006 03:09 AM
system tables and stored procedures recovery prob. mukund SQL Server 2000 1 December 24th, 2004 07:22 PM
Uploading database tables/stored procedures Jan_Ma Classic ASP Databases 2 June 17th, 2003 11:09 AM




Contact Us - Wrox - Privacy Statement - Top

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.