SQL Server 2000General 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 p2p Programmer to Programmer discussion community. This is a community of more than 40,000 computer programmers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining our free Wrox p2p community you can post your own programming questions and respond to other programmers’ questions. Registered users also don't have to see the ads that are displayed to guests. Registration is fast, simple and absolutely free so please, join today!
Join today and post to win prizes! Post more to increase your chances of being Wrox’s top poster of the month.
hello,
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.
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.
transfer local database to web server
Linear Mode
