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.