Guide

Contact DeLorme Professional Sales for support: 1-800-293-2389 Page 89
3) Make sure that the SQL Server Configuration on the server you are connecting to has TCP/IP, named
pipes, and/or shared memory enabled depending on how you want to connect to the server. This can
be accessed through the SQL Server configuration manager on the server to which you are
connecting.
4) Make sure that the current user on the client computer has login access to the database server and
has the appropriate permissions for the level of access to the database that you want them to have.
If you are distributing the XMap installation over a network, then you can put the connection registry
entries into a transform and apply them to the XMap installation MSI. Make sure that you test these
settings on a test computer before distributing.
Migrating Layers to New Databases
Layers in older OpenSpace databases can be migrated to the new XMap 7 database version through a
bulk export and bulk import process using the Bulk Importer-Exporter which is included with XMap
Enterprise. You can use a SQL script (see sample below) to help automate the process by building a list
of the layers in the older database and copying this list into a .bat file. You will need MS SQL Server
Management Studio to do so.
The suggested steps are:
1) Create the new XMap 7 database(s) into which you want to migrate the layers.
2) Run the SQL script below against the older database(s) to build a result of all layers in the database.
You will need to change the SQL script below to reflect the old XMap database instance and the new
XMap 7 database instance.
3) Copy the results of the script into a .bat file and run it in the Bulk Importer-Exporter.
Note: The sample script will not be able to deal with layers with the same name in the same database.
Sample Script 1:
set nocount on
declare @name sysname
-- Fill out our source and target variables.
declare @SourceServer varchar(200)
declare @TargetServer varchar(200)
-- Fill in the server name.
SET @TargetServer = 'keith\XMAP7'
declare @ServerName varchar(100)