XFOR: How to Save Mapping Rules for LDE Using SQL (200715)


The information in this article applies to:

  • LinkAge Message Exchange 3.2
This article was previously published under Q200715

SUMMARY

This article explains how to use the SQL Server 6.5 query tool to dump the current Mapping Rules for version 3.2 of Linkage Directory Exchange (LDE) to Microsoft Product Support Services (PSS).

MORE INFORMATION

There are times when you need to dump the current Mapping Rules of a Linkage LDE environment to send to Microsoft PSS. To do so:
  1. Start the SQL query tool, ISQL/w. Verify that LSDXMMD is the selected database.
  2. Using ISQL/w, under the query window type setuser DXAdmin and on the Query menu, click Execute. This sets the user to DXAdmin. If this does not complete successfully, the next step will not function properly.
  3. Using ISQL/w, under the query window type SELECT * FROM MapFields, and on the Query menu, click Execute. In the Results window, it returns the current Mapping Rules for Linkage LDE. Save the results in an .rpt file called MapRules.rpt by clicking Save As on the File menu.
Modification Type:MinorLast Reviewed:4/28/2005
Keywords:kbhowto KB200715
©2004 Microsoft Corporation. All rights reserved.