Post reply

Export Oracle tables (or query) for import to SQL Server

  • March 3, 2016 at 1:54 pm

    #1862920

    I've managed to solve the first 3 issues using format files. The fourth issue can be solved by cleaning the data in a staging table using T-SQL (REPLACE(ColumnName, '""', '"')).

    For more information on how to use format files, check the following: http://www.sqlservercentral.com/articles/BCP+(Bulk+Copy+Program)/105867/

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • March 3, 2016 at 3:36 pm

    #1862952

    To build the format file I would have to manually configure based off of custom field separators (per field), i.e., one of these four conditions:

    ",

    ,"

    ","

    ,

    That's for 500+ columns. That's simply not a route I'm going to take. I'm shocked this is the only viable solution with the given Microsoft toolset.

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply