Migrating BCM 2003 to BCM 2007

[Jack Hinkes]

How do you convert a BCM 2003 database to the 2007 version?
I am using the same SQL database engine or server and can't see the 2003
version of the databse from BCM 2007.

 

[Luther]

How do you convert a BCM 2003 database to the 2007 version?
I am using the same SQL database engine or server and can't see the 2003
version of the databse from BCM 2007.

Generally, when the owner of a database first opens Outlook/BCM after
upgrading BCM, BCM will allow them to select an exisiting database,
and upgrade the database if it's from a previous version. Your mileage
may vary depending on where database files are physically located
(e.g. BCM looks in the default folder on the client machine; BCM 2003
and 2007 use different database engines--versions of Sql Server) and
other factors. You can select a database from BCM, and old databases
will get converted to the new version.

 

[Jack Hinkes]

Generally, when the owner of a database first opens Outlook/BCM after
upgrading BCM, BCM will allow them to select an exisiting database,
and upgrade the database if it's from a previous version. Your mileage
may vary depending on where database files are physically located
(e.g. BCM looks in the default folder on the client machine; BCM 2003
and 2007 use different database engines--versions of Sql Server) and
other factors. You can select a database from BCM, and old databases
will get converted to the new version.

Thanks for the reply, however, I am trying to connect to a shared
database running on an SBS machine and although I can connect to the
data engine with a BCM 2007 client it does not list or show as available
the BCM 2003 version of the database.

 

[Luther]

Thanks for the reply, however, I am trying to connect to a shared
database running on an SBS machine and although I can connect to the
data engine with a BCM 2007 client it does not list or show as available
the BCM 2003 version of the database.

I think you need to attach the 2003 database to the BCM 2007 sql
server instance on the server. Then, it will show up, and when you ask
BCM to use that database, the database will be upgraded to 2007.

BCM's Database Tool may have a way to attach the database, and perhaps
even upgrade it.

If not, you can attach the database using SQL. Here's an example:
http://beyng.blogspot.com/2006/03/how-to-attach-database-files-to-sql.html

Attaching can also be done with Sql Management Studio.

 

[Jack Hinkes]

I think you need to attach the 2003 database to the BCM 2007 sql
server instance on the server. Then, it will show up, and when you ask
BCM to use that database, the database will be upgraded to 2007.

BCM's Database Tool may have a way to attach the database, and perhaps
even upgrade it.

If not, you can attach the database using SQL. Here's an example:
http://beyng.blogspot.com/2006/03/how-to-attach-database-files-to-sql.html

Attaching can also be done with Sql Management Studio.

The 2003 version of the database is already attached to the server. I
can open the 2003 version with a 2003 client and I have created an empty
2007 version on the same SQL server. I can see and connect to the 2007
database with a 2007 client, but don't even see the 2003 version of data
with a 2007 client. Is there a way to upgrade the 2003 database using
SQL commands and scripts?

 

[Luther]

The 2003 version of the database is already attached to the server. I
can open the 2003 version with a 2003 client and I have created an empty
2007 version on the same SQL server. I can see and connect to the 2007
database with a 2007 client, but don't even see the 2003 version of data
with a 2007 client. Is there a way to upgrade the 2003 database using
SQL commands and scripts?- Hide quoted text -

- Show quoted text -

Well, BCM has a way if you created a local database with 2003, then
upgraded, and BCM 2007 find the database in your default folder for
BCM databases. If the database is on another machine, that won't work.

An alternative may be to backup the 2003 database with BCM 2003, then
switch (upgrade, or use another machine) to 2007, create a new
database, then restore the 2003 db backup with BCM into the new db.
BCM should/may detect that the backed-up database is 2003, and migrate
it to 2007.