[thelist] Transfer SQL databases on disk

aardvark roselli at earthlink.net
Wed Jan 23 00:12:41 CST 2002


> From: "Jason Lustig" <lustig at acsu.buffalo.edu>
>
> >Is there a way to transfer MS SQL database to a disk to save and
> >later put on another machine, all the while maintaing tables and
> >data?
[...]
> (2) make a backup of the database on the computer you're transferring
> data *from*, and then restore the database on the other computer.
> 
> I'm not sure of that, so... well, it's worth a try...

that's the way i've done it... you'll need to re-index it and make sure 
it's all good (not to mention setting up the DSNs and all on the new 
machine), but that's your best bet from my experience...





More information about the thelist mailing list