transfer a database from the testing server to the new server

  • i have created a database in my server where i used visual basic as front end and sql server 2000 as back end. now the problem is that i was able to create a setup for my visual basic program, but how can i transfer this database in sql server to my client's system. I have no network connections to my client's system. I have to use only cd's. any suggestions??

  • How big is your database ?  If it's fairly small, you can back up the database, which creates a .BAK file, put that on the CD, then put it on your target machine & do a restore.  You could Zip the backup file if needed.  You might need to script out Login information as well.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply