Hopefully not too dumb of a question here. I'm more used to dealing with postgresql dumps that are easy to import into a new database.
In this case a client wants "their database on a cd" as they put it. It currently resides on an ISP server and the client is setting up their own (whether that's a good idea is another story). The database is SQL 2000.
I know I can make a backup, but I've tried using the backup method before to do a "copy" from one server to another and it didn't work due to something being different in the server (in other words, I took a backup generated on one server and tried to restore it on another).
Should this work? Should I be able to generate a backup (once I pull the db down to my local server from the ISP) that will restore correctly on the client's server?
Generating sql scripts only gets the structure, but I need the data too.
I would love to tell this client to use Enterprise Manager to connect and grab the db through export/import, but I'm not in a position to do so (politics).
I'm sure this sort of thing is needed as people transfer to different hosts. Any suggestions?