This is a small utility application that I wrote to help retrieve data from an Oracle source database, then to create the structure dynamically in SQL Server and perform a Bulk Copy. I put a GUI on top of it so that you can use this to test multiple connections and queries.
This utility performs the following steps:
- Retrieves the data from Oracle through a
OracleDataReader - Converts the
OracleDataReaderto aDataTable - Creates the SQL Server Tables based on the
DataTableStructure - Performs a
SQLBulkCopyof theDataTableinto the new SQL Server tables.
Click here for details ......
No comments:
Post a Comment