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. ThanksPTP


---------------------------------
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
MS Sql Server LazyDBA home page