Re: converting .dmp to .csv

From: Herod <herodt_at_gmail.com>
Date: 10 Mar 2006 11:43:32 -0800
Message-ID: <1142019812.881044.223180@j52g2000cwj.googlegroups.com>

Use ODBC and MS Excel, create an external query to the database you want as select * from table you want.

Save the excel as .csv

Save the .xls too. Then when you need to redo the data, you can.

Good for 1 or 2 tables

Or if you want to skip the .csv, use Access, do table links and then update queries
You can schedule those items... or so I am told. quick .vb script on the windows server to replicate the data.

Good for lots of tables.

OR
use XDB in oracle, dump the tables to XML and load XML into sqlserver

Geez... after typing ODBC,EXCEL,ACCESS,SQL SERVER, XML I have to go have shower... I feel DIRTY. Received on Fri Mar 10 2006 - 13:43:32 CST