Post reply

transact sql 7 to sql 2000

  • February 10, 2005 at 12:33 am

    #185067

    Hi everybody!

    I' ve tried to transact a database from SQL server 7.0 to sql server 2000 several times. I had problems with the primary keys, they were always lost. Furthermore the varchar have been converted to char. So I had to select varchar in each table in the settings and had to put the primary keys manually.

    Is there an easier way to copy a database from sql 7 to sql 2000 without losing the primary keys and converting the datatypes?

     

    Thanks in Advance,

    Andrea

  • February 10, 2005 at 5:35 am

    #541550

    Have you tried DEATTACH/REATTACH or restoring from SQL 7 > SQL 2K????



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • February 11, 2005 at 7:25 am

    #541798

    Dear Newbie,

     

    I am one too however, a few weeks ago I had a problem trying to restore a SQL7 db to a SQL2K and never could get it to work. I kept getting a collation error. Finally I talk to my SQL gurus and they gave me the suggestion of creating a new db that had the same collation and after that my restore worked. I know you didn't mention a collation problem but that might be something to consider.

    Harry

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

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