SQL Server Performance

any limit when you transfer a table?

Discussion in 'SQL Server DTS-Related Questions' started by mba1979, Jan 28, 2004.

  1. mba1979 New Member

    Hi!

    I'd like to know if there are any limit when you transfer a table from SQL Server 7.0 to an Oracle database. I did some DTS without any problem but i have a table with 38 columns and i can`t find why i can't transfer it to Oracle completely.
    At last, i did transfer only 31 columns. I would like to know if there is any configuration parameter in DTS package and how i can change it in order to tranfer the whole table, with its 38 columns.

    Thanks a lot!
    MARTA.

  2. bradmcgehee New Member

    This works fine in SQL Server, so I suspect it is an Oracle-related issue. I don't have any experience with Oracle, so I can't offer any specific advice. If you can't find a solution, one option would be to export the data from SQL Server in the comma-delimited format, then import it into Oracle.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com

Share This Page