Prev: Strip the first byte from an image column.
Next: Book recommedation for Oracle Developer
From: theintrepidfox on 10 Jun 2010 08:48
Hello. A client is moving a critical database from a German system to a US English system this weekend. Are there any known issues or anything we need to look out for? E.g. in terms of umlauts and accents etc

---
frmsrcurl: http://compgroups.net/comp.databases.ms-sqlserver/
From: Erland Sommarskog on 10 Jun 2010 16:16
theintrepidfox (user(a)compgroups.net/) writes:
> Hello. A client is moving a critical database from a German system to a
> US English system this weekend. Are there any known issues or anything
> we need to look out for? E.g. in terms of umlauts and accents etc

It is unclear what "German system" and "US English system" means here.

If you are referring to the system locale of windows, there should be
issues.

If you are moving the database from a server instance with one collation
to another, there might, if the queries were not written initially to
run a different collations in server and database.


--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

From: Erland Sommarskog on 10 Jun 2010 16:18
Erland Sommarskog (esquel(a)sommarskog.se) writes:
> It is unclear what "German system" and "US English system" means here.
>
> If you are referring to the system locale of windows, there should be
> issues.
>
> If you are moving the database from a server instance with one collation
> to another, there might, if the queries were not written initially to
> run a different collations in server and database.

I also occurs to me that if you create the logins from scratch there
may be issues with dateformats.

But it is a little difficult to answer such an open-ended question.



--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 | 
Pages: 1
Prev: Strip the first byte from an image column.
Next: Book recommedation for Oracle Developer