Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 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 April 21st, 2004, 02:01 AM
Registered User
Join Date: Apr 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default transfer local database to web server

I have an existing database (sql server 2k) as well as backup database. the problem is how do I transfer or restore it into my web host server database.

1. my web host server provide me an IP address with user name and pwd. I have no problem connecting it by unsing Enterprise Manager 2k.

2. the user name only have permission (owner) only

3. I have tried using DTS, it won't work

4. I have tried to restore my database on my local machine to my web host but won't work.

Please help me, how do I transfer my existing database well include datas and store procedure to my web server. the tech support are help less. all the said is using enterprise manager. I have no problem to re-create new table or store procedure on web server database, but I have more than 43k datas were store in table that I want to upload to web server.

thank you
Old April 22nd, 2004, 05:55 AM
Friend of Wrox
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post

I would say, you backup the database locally and copy the backedup database file to your web host server, and restore it there using EM. That should help you if you have permission to copy files to your web host server.


-Vijay G

Similar Threads
Thread Thread Starter Forum Replies Last Post
Slow load times with VS local Web Server stevemilton ASP.NET 2.0 Basics 12 June 29th, 2008 11:07 AM
transfer database from Paradox to Sql server 2000 oveisi SQL Language 1 November 26th, 2007 05:40 AM
How to Transfer web project to a different server yaduo VS.NET 2002/2003 1 October 11th, 2006 04:58 PM
How do i export data fom local database to server gnel2000 SQL Server ASP 1 February 24th, 2005 12:08 AM
connect from web server to remote database Durwood Edwards Classic ASP Databases 0 June 24th, 2004 01:03 PM

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