Hello....
I have a BCM 2007 database running locally on a SQL 2005 Express instance
(MSSMLBIZ). My goal is to move this database to a MSSQL 2005 Express Instance
(MSSMLBIZ) installed on a server rather than running locally. I went through
the following process...
1. Using the BCM Admin - Backed up the DB to an .sbb file on the client
machine
2. Using the BCM Admin - Created a new BCM database on the server.
3. Using the BCM Admin - Restored the backup to the database on the server.
4. Using the BCM Admin - Shared the BCM database on the server, recorded the
ugly connection info from the subsequent instruction screen in the admin
tool.(server\MSSMLBIZ,1121)
5. On the client machine, connected to the new server BCM database.
However, upon examination, I only had 46 contacts rather than the 251 that I
expected. I figured I would call it a night and connect back to the local
database at this point.
Yikes.... I could no longer see any valid BCM databases on the local
machine. I can connect to that database fine via SQL Management and it has
all 251 databases but Outlook BCM does not list that database when I specify
the local machine anymore.
So, by following a fairly straightforward and non-destructive process (I
thought), I now have no data for BCM.
I eventually 'tricked' BCM to connect to the old database by telling Outlook
BCM to create a new database and then I replaced the .mdf and .ldf files in
SQL while the service was off. Now, I don't expect that was the best way to
do this, but alas, I had no other options.
Can anyone shed some guidance on how to...
1. Migrate a SQL Express database from a local machine to a server?
2. If a perfectly valid BCM database is sitting on a server in the MSSMLBIZ
instance, why doesn't outlook recognize it? Is there a toggle somewhere that
turns these on and off?
I would *love* to get any sort of feedback on these topics to help
understand how to get these lovely BCM databases working like standard SQL
databases in *any* way possible. :-) :-)
thank you....
j
|
Similar Threads
