Hey everyone,
We are migrating our BES Express 5.0.1 server (VM) to a new BES Express 5.0.3 (VM).
So far we have the original BES on a separate VM server with a SQL 2008 Database. The new BES is installed on a separate VM with a SQL 2005 Databases. Our plan was to install the new VM separately and use BES Transporter to move the users over.
I have configured the Source (5.0.1 w/ SQL 2008) and Destination (5.0.3 w/ SQL 2005) Database. The Destination Database links up fine, but the Source Database is returning an error: "Unable to initialize the source database! Please check your setting and re-test the connection Error: Invalid object name 'ServerDBVersion"
When I test the connection I get a green check mark, but something is faulting durring the initialization.
I queried the 2005 Database (SELECT * FROM ServerDBVersion) and it returns three rows that appear to list the components of the Blackberry Databases. When I query the SQL 2008 Databases I get an error: "Invalid Object Name."
Does BES 5.0.1 not create this table? Anyone know of a fix or workaround?
These are the results of the SQL 2005 Query
ID CurrentVersion CreateDateTime BuildDateTime DisplayVersion
1 4.1.2 2012-05-08 15:31:33.563 2009-07-16 00:00:00.000 4.1.7
2 4.5 2012-05-08 15:31:45.793 2008-07-16 00:00:00.000 5.0
3 5.0 2012-05-08 15:32:27.320 2011-02-11 00:00:00.000 5.0.3
**CreateDateTime is when I installed BES so this table is created by BES, not SQL. No other progran would be able to use this table without context.
