I have a database on my laptop and I want to put it on my desktop. Does anyone know how I can copy this from one machine to another?? I'm running SQL Server 2000.
Printable View
I have a database on my laptop and I want to put it on my desktop. Does anyone know how I can copy this from one machine to another?? I'm running SQL Server 2000.
This may be obvious, but you could network the 2 computers together and copy that way. Failing that, you could hook up a CD burner to the laptop and copy the database onto a CD so that it could be copied to the desktop. There may also be some kind of Internet solution - look for a site that will enable you to upload the file from your laptop, then you could download it from your desktop. These are the only things I can think of right now.
Assuming you are running SQL 2K on the desktop . . . . As BruceG says, network the two together (either X-over or thru a hub) then open Enterprise Manager (or whatever it is in 2K) on the desktop. Register a new server (ie your laptop) and open the db on this new connection. Right click the db you want to transfer - select export and then follow the wizard. The source should be automatically defined - so define the destination as your desktop and select NEW as a database. The wizard will ask for a DB name - name it the same as the laptop. Then just follow the wizard to the end . . . .
Good luck . . . .
Thanks so much. The things you dont think of when your alittle intoxicated..;)