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.

  • Selecting top row in a many to many relationship with custom join table
  • Create Duplicate SQL Database for Testing
  • Select a specific column based on another column's value
  • MSSQL replace isue
  • What does TOP 1 mean in an sql query?
  • Calculate the each product(Inkcode) stock
  • 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.

  • SQL Server simple Insert statement times out
  • What does =* mean?
  • type of loops in sql server?
  • Login failed for user. Trying to access a SQL Server Express database
  • SQL values for min and max rows in one row
  • Export table from database to csv file
  • 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.