moving data from one database connection to another
Here is my current dilemma:
I have a table located in an Oracle database, from which I would like to
copy its ID field records into a temporary table within a SQL Server database,
so I can run a INSERT INTO...SELECT query. My dilemma is what is the best
and fastest way to mass insert that data into the temp table from one ODBC
connection through another. I would like to rule out the record by record
single line insertion process...is there a better way, a way to perform a
mass insertion from one ODBC connection recordset into the other ODBC connection?
Please help, do not want to go line by line...
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL