I have an SQL server 2005 database on my laptop and i want to copy it to my machine at wotk. The two machine can't be connected other than through internet. I am unable to figure out a way to do this. Anyone has any ideas ?!?! Thanks !!
Hi,
You could do an object transfer with DTS or SSIS to the target machine, but that would imply opening some ports to your work machine which is (in the most cases) hardly possible. The best way to do a data transfer is either to detach your db , copy it over and attach it to the working machine OR backup your database copy it over and restore it again on the target system.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment