d*******r 发帖数: 432 | 1 need to create a new database on a machine that has ms sql server 2000 chinese
version, but later the database will be moved to a machine with english
version, eg. using detach/attach.
if all the data are in english, would there be any problem?
never used the chinese version b4, thanks ! | p*********s 发帖数: 2 | 2 As long as you define the character using the right character sets, it should
be no problem.
Even you define the character sets as GB2312, as long as the english version
also had that character sets installed, and choose that as default character
sets, the moving will not be a problem either.
DTS, Data Transformation Service, will do that for you.
However, never done that before, just my thought. It would be save to define
the character sets as English sets and try to avoid using the NCHAR.
【在 d*******r 的大作中提到】 : need to create a new database on a machine that has ms sql server 2000 chinese : version, but later the database will be moved to a machine with english : version, eg. using detach/attach. : if all the data are in english, would there be any problem? : never used the chinese version b4, thanks !
|
|