Moving databases between computers
HyperLab makes it possible to transfer all your data in your databases from one computer to another. There are plans to implement an export – import utility, which will be able to transfer standalone data items between databases, but it is not implemented yet: only complete databases may be transferred.
There are basically two methods for transferring databases between computers:
Backup the database and restore it on another computer. This way one single backup file is created, which can be easily transferred to another computer where it is restored as a new database. This is the preferred method.
Detach and attach database files from the local database server. This method makes it possible to make a copy of the *.MDF (data) and *.LDF (log) files of the database and transfer it to another SQL Server. Use this method only if backup fails.