SQL 2000 Portable DB

[whathappened9]

Hello,
I was not sure how to title this post. Anyways, I am using MS SQL 2000 and visual Studio 2005. I have done some projects where the database will only work on my PC. If I try uploading the the project to some other PC/Server it will not work. Some one mentioned importing the DB, but I have no idea how to do this. I hope the problem is clear.

Thank you

[russell]

what version sql2000? developer edition?

how does client code connect to db?

did u create database on server? how?

[whathappened9]

Thanks for responding. The DB is SQL 2000 Developer Edition, and I will be using Visual Studio 2005 Pro. I haven't started on the DB side of the project,that's why I am asking . The plan is to develop on my machine then upload the whole thing to a server.

Thank you

[russell]

make sure host supports mssql 2000. other than that, should be no problems

[whathappened9]

The problem I am facing is when I used SQL 2005 I can just add a .mdf file to my project and operate on it. Now I can connect to the SQL 2000 but where is the file that contains my tables which be uploaded later to some server. Sorry if my question seems silly.

thank you

[russell]

can't do it like that when upload to server. need to either backup/restore to target server, or use sp_detach_db/sp_attach_db to manually copy .mdf and .ldf file. can also use dts to target server, in which case need to create the db on server first.

mssql databases don't work with just one file. need both the data file (mdf) and the log file (ldf), and the sqlserver.exe service running on host server

[russell]

if the server is a hosted site, find out what method they recommend. they may not be willing to restore a backup for you, nor attach a db. some hosts only allow objects to be created directly on host server (for security reasons). also, if restoring backup, still need to create users on target server.