BCM database scheme

tlassner

Senior Member
Outlook version
Outlook 2013 32 bit
Email Account
Exchange Server
Hello together,

does anyone has got a database scheme/ diagramm with all relations, primary and foreign keys of the BCM Database?

would be very helpful for MS Access queries (just reading) on the db.

the most important for me is to see where the user defined fields are defined.

thx

Tobias
 

tlassner

Senior Member
Outlook version
Outlook 2013 32 bit
Email Account
Exchange Server
would be nice if you could post it when back. maximum success on your business trip
 

tlassner

Senior Member
Outlook version
Outlook 2013 32 bit
Email Account
Exchange Server
Hello again,

I generated the database scheme of the BCM database with schemaSpy.

Download, unzip and start index.html in /BCM_Prod:

https://www.dropbox.com/s/go9grlwz81k9ujy/BCM-dbScheme.zip

hint: If you want to access the "userfields" via MS Access you have to cast the binary field into another datatype, e.g. string:

query example:

SELECT CStr(dbo_ContactCatIMAPIView.UserField1) AS [title of user defined field as shown in query]

FROM dbo_ContactCatIMAPIView;
 

jumana

New Member
Outlook version
Outlook 2016 64 bit
Email Account
Exchange Server
Here include about the databased informations.this details are very useful for me.it include more functions and informations are .included in this blog.i got a cl.ear information.thanku so much for including this blog.sugar sachets dubai
 
Similar threads
Thread starter Title Forum Replies Date
J No access to a Database BCM BCM (Business Contact Manager) 3
G Windows Update Causes BCM Database Access Problem? BCM (Business Contact Manager) 4
T Lost access to remote BCM database BCM (Business Contact Manager) 4
L Cannot Connect to BCM database BCM (Business Contact Manager) 9
A Cannot connect to BCM database BCM (Business Contact Manager) 3
Diane Poremsky Restoring BCM Database After Upgrading Windows New Slipstick.com Articles 0
M Modifying BCM Database using Access BCM (Business Contact Manager) 1
crazyboy Copying BCM database from backed up mounted image to new drive BCM (Business Contact Manager) 2
J Install BCM Client without an local SQl Database BCM (Business Contact Manager) 6
M Sharing of BCM database across the internet BCM (Business Contact Manager) 2
Chris Grew Sharing BCM Database BCM (Business Contact Manager) 6
M BCM remote database connection issue BCM (Business Contact Manager) 1
J What exactly does the BCM Database tool actually do? BCM (Business Contact Manager) 3
C Moving BCM Database to Server Share BCM (Business Contact Manager) 1
K BCM - Connecting to Shared Database BCM (Business Contact Manager) 0
J Can the BCM Database tool be used over VPN? BCM (Business Contact Manager) 6
D can you share a bcm database with 2 different versions of windows? BCM (Business Contact Manager) 0
E BCM Database Tool Using Outlook 2
G "database is not compatible with BCM for Outlook 2013" & more BCM (Business Contact Manager) 0
L BCM database not listed BCM (Business Contact Manager) 0
J No errors from BCM 2007 but can't see database BCM (Business Contact Manager) 0
P BCM 2013, Microsoft SQL Server 2008 R2 (SP2), attachment issue n database size BCM (Business Contact Manager) 2
T BCM Cannot See Existing Database BCM (Business Contact Manager) 2
T Shared BCM database on remote server BCM (Business Contact Manager) 1
C My BCM Database is no longer available to be shared with the Database Tool BCM (Business Contact Manager) 3
wallisellener Server configuration for BCM 2013 shared database BCM (Business Contact Manager) 15
M BCM in Outlook reports maximum database size to 4GB despite SQL Server 2008 R2 BCM (Business Contact Manager) 1
D BCM Database Protection BCM (Business Contact Manager) 3
M BCM 2010 Cannot Connect to Remote Database BCM (Business Contact Manager) 1
J Unable to view History items in BCM 2007 shared database BCM (Business Contact Manager) 3
E Accessing User Defined Fields in BCM Database part 2 BCM (Business Contact Manager) 0
E [SOLVED] Accessing User Defined Fields in BCM Database part 1 BCM (Business Contact Manager) 9
C Remote BCM database 2010 hosted via Godday SQL Server + access via PC Window 7 BCM (Business Contact Manager) 3
D Writing to BCM Database from VBA BCM (Business Contact Manager) 0
R Missing contacts and Opportunities in BCM 2010 Shared database BCM (Business Contact Manager) 1
R BCM 2010 error creating offline copy of shared database BCM (Business Contact Manager) 1
S Restoring Database to BCM BCM (Business Contact Manager) 2
C BCM database second user BCM (Business Contact Manager) 1
P Download BCM Database BCM (Business Contact Manager) 1
D Sharing BCM Database with other computers on a network BCM (Business Contact Manager) 1
A BCM 2007 restoring database BCM (Business Contact Manager) 1
A BCM database and Windows 7 BCM (Business Contact Manager) 1
I Can I share BCM V2 Database on 2003 by using BCM Data Admin Tool BCM (Business Contact Manager) 2
T Error 'Database msdb cannot be opened' when backing up BCM BCM (Business Contact Manager) 2
D Connecting BCM 2007 to a shared BCM 2003 Database BCM (Business Contact Manager) 3
E How to restore BCM Database after upgrade from Vista to Win7? BCM (Business Contact Manager) 1
A BCM 2010 & remote database BCM (Business Contact Manager) 3
A BCM 2007 Shared Database on member Server 2008 in SBS 2008 Domain BCM (Business Contact Manager) 1
P Where are User-defined fields stored in BCM 2010 database? BCM (Business Contact Manager) 2
Y hosting BCM database at office online / workspace BCM (Business Contact Manager) 2

Similar threads

Top