User`s guide

9030971 E17

9-1

Chapter 9

Microsoft SQL Server Exports (NT)

Provides information about Microsoft SQL Server export requirements.

Conﬁguring the dtxscript File

To export to Microsoft SQL Server tables, you must conﬁgure the dtxscript

ﬁle, which is located in the SG-Tools directory.

Modify the script’s “Necessary SQL Server additions” section as follows:

• The SERVERNAME variable must be uncommented (remove the #

character). Add the name of the machine on which the Microsoft SQL

Server database resides to the right of the = sign.

• The export SERVERNAME command must be uncommented.

• The SQLSERVER variable must be uncommented. Add the name of the

server to the right of the = sign.

• The export SQLSERVER command must be uncommented.

• If you want Models exports to display more than the ﬁrst 32 characters of

model names, you must change the value of the SDE_OUTPUT_MODEL_LEN

variable. For Microsoft SQL Server, you can specify display of up to 255

characters.

When this script executes, the Microsoft SQL Server environment variables

are exported.

NOTE

Microsoft SQL Server is available as on output format option on the NT

platform only.