Network Computing is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them. Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

In order to simulate an

In order to simulate an enterprise environment we cooked up a company, complete with customers, products and even order histories.
But in order to make it come to life, I've spent the last week in a fugue, moving from PERL to shell script and back, generating megabytes of simulated everything.

Some of the work I've done on Linux in MySQL and need to migrate to SQL Server. Defining the databases was simple, and you'd think all you'd need to do then is dump the data and import into SQL Server.

Not true. Oh not true at all. SQL Server choked on integer columns with lengths, and absolutely would not accept the "auto_increment" attribute. Well, it's only a few tables, so I edited the files to make SQL server happy and then redefined the tables within Enterprise Manager.

Then I tried to import the actual data. isql, the CLI for SQL Server, did not like the generated files designed to do bulk inserts. I fixed them one by one and managed to import the smaller ones. But I hit a snag I couldn't get around - "out of memory" . 1GB of RAM on this beefy machine and it's out of memory importing 200,000 rows?

Eegads. I was in trouble. The last two files had 200,000 and 600,000 records each, respectively. I moved to DTS to pull the data.