Populate an SQL Server 2k8 with Oracle Loader files

Posted by Techpriester on Stack Overflow See other posts from Stack Overflow or by Techpriester
Published on 2010-06-07T06:26:02Z Indexed on 2010/06/07 6:32 UTC
Read the original article Hit count: 382

Hi folks.

Here's the problem:

I have a project that needs to be migrated to Microsoft SQL Server 2008.

We have data in text files for the Oracle SQL Loader and now we need to get that data into the SQL Server DB.

I could write a program that converts everything into INSERT statements but there has to be a more comfortable way to so this.

Any suggestions?

PS: I don't think my company wants to buy additional Software to do this job so that's out.

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about database