Code page

• scorpvo

  SSCommitted

  Points: 1769

  More actions

  May 13, 2003 at 3:50 pm

  #59225

  I got a backup db file on SQL 7 w/ code page CP 1252 and need to install on another SQL 7 w/ code CP 850. It failed bcz of the code page different. Is there any easy solution beside recreate the db and import the data? thank in advance...

• Antares686

  SSC Guru

  Points: 125444

  More actions

  May 13, 2003 at 7:25 pm

  #457052

  No, that is your easiest solution or you could BCP out the data and script the objects then do the same thing.

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  May 13, 2003 at 7:25 pm

  #457051

  You don't have other options beside eithrt BCP or DTS in and out in SQL Server 7.0.

  SQL Server 2000 allows databases having different collation under one instance.