Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004
    Posts
    2

    Unanswered: MSSQL import from MySql problem

    I have connected to my mysql db with myodbc. When I start importing I get errors on some varchar variables.

    Some of my varchar(255) becomes varchar(-1) when I import. When this happens smssql fails to create table.

    Anyone have a clue?

    Thanks.

    Getter..

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    MySQL is tempermental that way... Some versions emit nonstandard catalog information that other database engines have trouble interpreting.

    The simplest answer is to just create a script to recreate your schema, then load the data once the tables have already been created.

    -PatP

  3. #3
    Join Date
    Sep 2004
    Posts
    2
    Ok. Thanks


    Getter..

Posting Permissions

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