home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Chip 1997 January
/
Chip_1997-01_cd.bin
/
ms95
/
disk22
/
dir08
/
f002550.re_
/
f002550.re
Wrap
Text File
|
1996-04-02
|
2KB
|
63 lines
MicroStation ODBC SQL Server README.TXT
This readme file explains the batch files used to create
the mscatalog, gis example tables and load the example
GIS data in your SQL Server database.
bldmscat.bat
Usage: bldmscat database_name username password
Example: bldmscat gis scott tiger
Creates the mscatalog table.
bldgis.bat
Usage: bldgis database_name username password
Example: bldgis gis scott tiger
Creates the tables for the gis example.
loadgis.bat
Usage: loadgis database_name username password
Example: loadgis gis scott tiger
Loads the example data into the GIS example tables and the
mscatalog.
NOTE: This batch file uses BCP, a SQL Server bulk copy utility. BCP
can not load data into a table unless it has an index OR the database
option 'select into/bulkcopy' is set to true. Since the 'mscatalog'
and the 'parcel_das' table do not have indexes, the bulkcopy database
option must be set to TRUE. To set the bulkcopy database option, run:
setdbopt.bat
Usage: setdbopt database_name copy_boolean sa_password
Example: setdbopt gis true manager
This will turn on the option and you can run 'loadgis' again and
successfully load data into the mscatalog and parcel tables. After
all data is loaded, you must set this option back to false, or the
dump statement will return errors. The statement to set the option
to false could look like the following:
Example: setdbopt gis false manager
SAMPLE Flow of Execution...
This sequence creates the mscatalog table, the gis example tables,
sets the bulkcopy database option to true, loads data into the
mscatalog and gis tables and finally sets the bulkcopy dboption to
false.
bldmscat gis scott tiger
bldgis gis scott tiger
setdbopt gis true manager
loadgis gis scott tiger
setdbopt gis false manager
Where:
GIS is the destination database for the example tables and data.
SCOTT is a user that has dba priveleges for the GIS table.
TIGER is SCOTT's password.
MANAGER is the password for the SA account
TRUE is the parameter to setdbopt that turns the copy db option on.
FALSE is the parameter to setdbopt that tuuns the copy db option off.
The end.