Some options:
When you bring SQL Server into the mix you allow the opportunity to use Data
Transformation Services (DTS). DTS can connect to flat files or ODBC or
OLE-DB databases. You can create "packages" (basically a transformation
program) to transfer the data between database systems, compare data etc.
Alternately you could use it simply to create the text files (or you can use
bcp for SQL Server).


Brian Freeman
(770) 916-0595 ext. 415
Carnegie Technologies/Bluewave Computing
www.carnegie.com and www.bluewave-computing.com

-----Original Message-----
From: manage data [mailto:[Email Address Removed] Thursday, April 17, 2003 5:46 PM
To: LazyDBA.com Discussion
Subject: Fwd: common SQL statments for ORACLE/DB2/SQLSERVER


Hi Guys

I want to create FLAT FILE from SQLSERVER tables data and DB2 tables. What
is best option we have ?

Basically I want to synchronize two databases (offline synchronization) and
databases may be (SQLSERVER, DB2 , ORACLE) . I was thinking of writting
PERL script which will talk to database (DB2/SQL/ORACLE) and create FLAT
FILE from data. and when Uploading to databases , for Oracle we have SQLLDR
or equivalent for DB2/SQLSERVER.

Another option i was thinking is writting common SQL statements.


Please guide me in this. I donot know anything about DB2/SQLSERVER.

Thanks
PTP




_____

Do you Yahoo!?
The New <http://us.rd.yahoo.com/search/mailsig/*http://search.yahoo.com>
Yahoo! Search - Faster. Easier. Bingo.

MS Sql Server LazyDBA home page