Post reply

problem in importing database

  • September 17, 2003 at 11:21 am

    #106228

    I have been trying to import database from SQL 7 to SQL 2000 but when I tried it gives an error message saying, "Syntax error converting the nvarchar value 'No Semester' to a column of data type int. Here 'No Semester ' is one of the values we put it in for one of the columns. Your help is appreciated. Thanks

  • September 17, 2003 at 6:06 pm

    #474778

    A bit more information would be really helpful. Can you post the structure of your SQL7 and SQL 2000 tables?

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

  • September 18, 2003 at 11:23 am

    #474917

    Thanks for your help Phil. Problem has been solved. What I did was instead of importing whole database, I tried one table at a time. Thanks

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

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