Results 1 to 10 of 10
  1. #1
    Join Date
    Nov 2003
    Posts
    8

    Unanswered: Need help with importing data into SQL Server table

    Hi everyone,

    I have a file that is a backup copy of an Oracle table. Is there a way for me to somehow extract the data from this file and import it into a SQL table using DTS? TIA

    Taz2

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Table or database?

    Flat file or dump?

    Yes and No...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Nov 2003
    Posts
    8
    Originally posted by Brett Kaiser
    Table or database?

    Flat file or dump?

    Yes and No...
    To be honest with you I don't know. I was expecting a pipe delimited text file to do the import but what I got is a file with a ".BCK" extension, when I view the file using Notepad instead of seeing data I saw CREATE statements... View, Stored Procedure, etc. I just assume that it's a backup copy of an Oracle table since my client uses Oracle, my question is can I use the backup file and how or my client will have to export the data from Oracle into a text file for me. Sorry to be so basic but I am learning this, TIA.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I don't think you can use a backup file...sounds more like DDL script to me though...

    Stuff like CREATE TABLE tablename (
    Col1 int...

    like that?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Nov 2003
    Posts
    8
    Originally posted by Brett Kaiser
    I don't think you can use a backup file...sounds more like DDL script to me though...

    Stuff like CREATE TABLE tablename (
    Col1 int...

    like that?
    Here is what in the file:

    CREATE VIEW syssegments (segmemt, name, status) AS
    SELECT 0, 'system' , 0 UNION
    SELECT 1, 'default' , 1 UNION
    SELECT 2, 'logsegment' , 0

    I have that all over the entire file. I figure as much but I just want to confirm before I go back to my client, thanks for your help.

  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Originally posted by Taz2
    Here is what in the file:

    CREATE VIEW syssegments (segmemt, name, status) AS
    SELECT 0, 'system' , 0 UNION
    SELECT 1, 'default' , 1 UNION
    SELECT 2, 'logsegment' , 0

    I have that all over the entire file. I figure as much but I just want to confirm before I go back to my client, thanks for your help.
    Well it's not a dump...what's the exact name of the file?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  7. #7
    Join Date
    Nov 2003
    Posts
    8
    Originally posted by Brett Kaiser
    Well it's not a dump...what's the exact name of the file?
    The name of the file is Elig.bck. Originally the file was sent to us Encrypted in this format Elig.zip.pgp, we decrypted to the zip format and when we unzipped it we got the .bck file.

  8. #8
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Did they say what the file was for?

    Do you see a lot of things like..

    INSERT INTO myTable99 (col1, col2, ect
    VALUES ('a','b','ect)

    Statements?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  9. #9
    Join Date
    Nov 2003
    Posts
    8
    Originally posted by Brett Kaiser
    Did they say what the file was for?

    Do you see a lot of things like..

    INSERT INTO myTable99 (col1, col2, ect
    VALUES ('a','b','ect)

    Statements?
    There is no INSERT statement anywhere in the file. I was expecting pipe delimited text file containing data for data warehousing purposes, I think what happend is instead of export the data from Oracle into SQL then send to us they just send us a backup copy of the table hoping that it will contain data.

  10. #10
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Originally posted by Taz2
    Here is what in the file:

    CREATE VIEW syssegments (segmemt, name, status) AS
    SELECT 0, 'system' , 0 UNION
    SELECT 1, 'default' , 1 UNION
    SELECT 2, 'logsegment' , 0

    I have that all over the entire file. I figure as much but I just want to confirm before I go back to my client, thanks for your help.
    It's not Oracle at all...syssegments is a sql server system table

    Better go ask for a pipe delimited file from them....how did they extract it...

    Last time I was in Oracle (8i) you had to write a package/procedure to get data out using put_line....

    Good Luck
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •