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.

  • Windows Event Log Access from SSIS package run in SQL Agent Job
  • SQL Server: how to create a stored procedure
  • SQL STDEV on a calculate column
  • Count of non-null columns in each row
  • What is the use of the square brackets in sql statements?
  • SQL slow subquery
  • 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.

  • How to perform efficient Bulk update in SQL server
  • Database normalization in archive systems
  • PHP and SQLSRV isn't inserting all the rows it should
  • How to merge these 2 queries
  • How do I change db schema to dbo
  • Centralizing / abstracting SQL Server data from multiple tables / databases
  • 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.

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.