WARNING: Use the following instructions at your own risk as the SQL Server Management Studio Express is a powerful tool and you risk making irreversible changes to your database. DeLorme does not explicitly recommend this option nor do we claim any responsibility for lost data when using this application.
If you are migrating to the same version of XMap, you can detach and attach an entire database.
First, download Microsoft SQL Server Management Studio Express:
For SQL Server 2005:http://www.microsoft.com/downloads/en/d ... 0f62bf7796
For SQL Server 2008:http://www.microsoft.com/downloads/en/d ... 76a8564a2b Instructions on Detaching/Attaching your database
After you have completed the Management Studio installation, open the application through Start>All Programs>Microsoft SQL Server (either 2005 or 2008, depending on what you use)>SQL Studio Management Express. The connection window should default to your local server. Press connect. Once you are connected to the local server, simply expand Databases, on the left hand side; find the database that is of interest. Right-click on the database and choose task>Detach. Once the Database is detached, navigate to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data and right click and copy on both the .mdf and .ldf file that corresponds to the detached databases name. Paste these files onto a jump drive or portable file transfer device.
On the new computer, create a new folder on your C drive and place the .mdf and .ldf files into this folder. Once this has been completed go to Start>All Programs>Microsoft SQL Server>SQL Studio Management Express. The connection window should default to your local server. Press connect. Once you are connected to the local server, simply expand Databases on the left hand side. Right click on Databases and choose Attach, navigate to the location of the previously created folder containing the ldf and mdf file. Select the file that is present and choose OK. The database should now be attached and ready for use via the XMap application.