Populate an SQL Server 2k8 with Oracle Loader files
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.
PS: I don’t think my company wants to buy additional Software to do this job so that’s out.
2 Solutions collect form web for “Populate an SQL Server 2k8 with Oracle Loader files”
SQL Server has a bulk loader interface, which you can learn about here.
Depending on what format it’s in now, you might also consider SSIS, which is supposed to be great at such things, and which you may already own with SQL Server 2008.
(I say “supposed to” because in my experience, it is so buggy and quirky that it’s usually faster to do it manually. YMMV.)
Have a look at http://www.sql-workbench.net/
It has some nice tools for bulk loading data.