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
 
Thread starter Similar threads 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
J BCM 2007 Cannot Connect to Shared Database Using Outlook 1
P Attempt to fetch logical page in database failed: BCM 2007 Using Outlook 1
B Creating an Offline Database with Outlook 2007 BCM Using Outlook 1
C Outlook 2010 with BCM - Database Connection problems using Windows 7 Clients Using Outlook 1
N Receive "Requested Operation Failed" Dialog when trying to add BCM Database in Outlook 2010 Using Outlook 2
A BCM-Problem Accessing Database Using Outlook 1
R BCM 2007 to 2010 Conversion fails - Database size > 4GB Help! Using Outlook 1
M Does a shared Outlook BCM 2007 database work with both Outlook BCM 2007 and 2010 clients? Using Outlook 2
F BCM Database Corrupt Using Outlook 3
M BCM error: Object reference not set to an instance of the object. Got this msg. BCM database will Using Outlook 2
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
Similar threads


















































Top