Bulk export usage

[jcarpenter]

I need to migrate an XMap DB to a new workstation, and am tired of fighting with the inexplicable errors thrown by the clumsy, lumbering behemoth known as DB Manager, so I want to do a bulk export of layers to .openspace files. I've read the bulk import/export utility docs and understand the batch file method indicated; however, as I want to indiscriminately extract every layer and not a select subset, is there an alternative method to pass a wildcard or the like to export all instead of creating a line for every layer name/id?

[KevinBE]

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.

[jcarpenter]

Thanks, I was successful with the DB transfer method indicated. Getting the SQL Management Studios Express was a bit hairy though. For future reference:

SMEE 2005 on Win 7 x64: run the *.msi installer from an elevated command prompt. "Run as administrator" from the explorer GUI looks like it will work, right up until it fails and rolls back at the very end of installation.

SMEE 2008: even though it's a standalone installer for Mgmt Studio, it is wrapped in the godawful atrocity known as SQL Server 2008 Install Center. Good luck. Choose to install a new instance; don't try to add features to the XMAP7 instance, as the installer will fail to progress with an utterly nonsensical error and you'll have to completely close out/restart the installer.