Post reply

Database upgarde from SQL 2000 to SQL 2008

  • September 19, 2011 at 9:47 am

    #390430

    Hi All,

    I'm upgrading SQL 2000 database to SQL 2008.I can find SQL 2000 collation on SQL 2008 as well.

    Is there any difference between SQL 2000, SQL_Latin1_General_CP1_CI_AS and SQL 2008 SQL_Latin1_General_CP1_CI_AS collation? or they are one and same?

    Is there any difference between SQL 2000 ' Latin1_General_CI_AS and SQL 2008 'Latin1_General_CI_AS'?

    collation? or they are one and same?

    Thanks in advance

  • September 19, 2011 at 9:59 am

    #1383383

    I am not understanding your question

    Take the backup in 2000 server save some where and restore the data base in 2008 make sure logins, user and dbo

    Later in 2008 server you can see the 200 server database just right click on that properties compability option like 100 and ok

    this is one way to get databases from 2000 to 2008

  • September 20, 2011 at 2:42 am

    #1383671

    Let me put it like this..

    Is there any difference between SQL 2000, SQL_Latin1_General_CP1_CI_AS and SQL 2008 SQL_Latin1_General_CP1_CI_AS collation? or they are one and same?

    Is there any difference between SQL 2000 ' Latin1_General_CI_AS and SQL 2008 'Latin1_General_CI_AS'?

    collation? or they are one and same?

    Thanks

  • September 21, 2011 at 2:59 am

    #1384373

    i think no but collation SQL_Latin1_General_CP1_CI_AS exist in 2008 !

  • September 21, 2011 at 6:35 am

    #1384442

    Both collation are same. There is no difference in collation eventhough SQL Server version changes. I prefer to install the same collation of SQL SERVER 2008 as SQL Server 2000.

    Cheers!

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • September 21, 2011 at 6:46 am

    #1384452

    Thank you all!

  • September 22, 2011 at 10:27 am

    #1385296

    Yes, both collations mean the same.

Viewing 7 posts - 1 through 6 (of 6 total)

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