Hi database experts,

I want to migrate data from old server to new server.
Both servers are on same MS SQL 7

Can I just copy baandb.mdf and baandb.ldf from old server to new server?
Either that, or can I copy the whole mssql7data directory from old to new server? This directory contains all the sql data including master.mdf etc etc.

SQL has been installed on the same directory names in both servers.

If this is acceptable, then it will save me a lot of time. In my testing, i created seq dump and create table from seq dump. This is taking very long time.

Anyone tried this before?? Need your input and advice

Thanks and regards,

See this for how we do it: http://www.baanboard.com/baanboard/showpost.php?p=40146&postcount=3