[thelist] Transfer SQL databases on disk

Chris Garrett chris at chrisg.com
Wed Jan 23 04:57:16 CST 2002


> backup of the database on the computer you're transferring data *from*,
and
> then restore the database on the other computer.


This does work if both servers are configured much the same (locales, etc).
Be VERY careful doing this unless you have full access to both servers (ie.
they are both yours).

A better way is to script the database and edit the text files that are
created so that users and permissions, etc are all ok, then export the data.
You will find if your data has long text fields that CSV sometimes truncates
and if you have NULL values that sometimes Excel moves data into the wrong
columns so Access might be your best bet.

Try the SQL gurus at http://www.aspfriends.com/ if you get stuck

HTH

Chris



--

NEW ARTICLE:

Warp an image on the fly with GDI+/System.Drawing
http://www.RealWorldASP.net

Don't miss the news! - Sign up for ASP/.NET Newsletter:
http://www.aspalliance.com/chrisg/subscribe.asp





More information about the thelist mailing list