Home Forums SQL Server 2008 Working with Oracle export/import error RE: export/import error

  • January 31, 2013 at 8:28 am

    #1583036

    lg123 (1/31/2013)

    One of the columns was nvarchar2(255). How do I successfully transport such kind of tables from SQL Server to Oracle? Please suggest.

    well there's only two solutions:

    1. modify the Oracle Table so the field is bigger, so it can accept strings longer than VARCHAR2(255), then repeat the process.

    2. Modify the Process to grab the LEFT(SQLField,255)

    the problem with the second is data truncation...the data is NOT exactly the same in both systems.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!