Migrating BCM2003 to BCN2007

[Anders]

I am trying to migrate from BCM2003 to BCM2007. I got two problems which I do
not know how to solve.

1. My BCM2003 is in english (Based on Outloot in SBS 2003) and my BCM2007 is
in swedish. The migration scripts in my swedish version does not work with my
english version of BCM2003. Where can I got the english scripts?

2. I read that the BCM-database must be in the same language as Outlook. Is
there a way to change the language of the BCM-database from english to
swedish?

3. Is there another method to migrate data from BCM2003 english to BCM2007
swedish except for the method indicated in question 1 and 2?

 

[Luther]

I am trying to migrate from BCM2003 to BCM2007. I got two problems which I do
not know how to solve.

1. My BCM2003 is in english (Based on Outloot in SBS 2003) and my BCM2007 is
in swedish. The migration scripts in my swedish version does not work with my
english version of BCM2003. Where can I got the english scripts?

2. I read that the BCM-database must be in the same language as Outlook. Is
there a way to change the language of the BCM-database from english to
swedish?

3. Is there another method to migrate data from BCM2003 english to BCM2007
swedish except for the method indicated in question 1 and 2?

One problem in this area is the collation sequence of the databases,
which controls how is sorted. So Sql experts have managed to work
around the collation. There are other potential problems with mixed
locales. As I understand the issue, the locale of Windows,
Office, .NET, Sql Server, and BCM itself, can all affect how BCM
behaves. BCM is only supported when they all line up--with an
exception for locales that don't have specific version of Sql Server.
There are too many locale permutations for BCM to support mixed
locales.

You could try exporting from BCM 2003 English to a BCM file, and then
importing that file in BCM 2007 Swedish.

 

[Anders]

Thank You.
I will try this and hope it will work. As I know, there is no swedish
version of SQL server. We have to use the english version.

 

[Luther]

Thank You.
I will try this and hope it will work. As I know, there is no swedish
version of SQL server. We have to use the english version.
--
Anders Bergquist







- Show quoted text -

In that case it's likely that BCM 2007 Swedish creates and expects a
database with Swedish collation order, while the BCM 2003 USA database
would use the US or UK collation, and that difference leads to
problems migrating the database from 2003 to 2007.

 

[Anders]

What exactly is collation (order)

 

[Luther]

What exactly is collation (order)
--
Anders Bergquist






- Show quoted text -

Search the internet for collation and sql server, and you'll find
this,
http://support.microsoft.com/kb/325335

And many other explanations, within one second--much faster than
asking someone else to run the search for you....

 

[Anders]

I tried to install the english triel version and export from it and import in
the swedish version. Everything look allrigth untill I open BCM in my swedish
Office. All posts was imported but not the data.

I also tried to follow the link about changing colation, but it does not
work for me because SQLEXPRESS does not have DTS and therefore, I could not
move the date from one database to another.

It is sad to say that we now have to leave BCM and all data because, or find
a way to reenter all data manualy. Do you have a method to manualy recreate a
BCM-database? or is there another way we does not think about?

We need the swedesh version of office. We not mix language only use the
swedish.