Microsoft Visio 2010 ERD using Custom Data Types from Database Drivers MySQL Oracle Access IBM DB2 ODBC


Microsoft Visio 2010 ERD (Entity Relationship Diagram)


Solution for matching data types on Microsoft Visio 2010 with your database needs.

Microsoft Visio 2010 – Limited Data Types


Hi guys! This topic discuss the solution on solving limited data types on Microsoft Visio. Previously, I was having some problem with data types when I am creating an ERD. The drop down combo box does not have a specific data type “TIMESTAMP” for my attribute “DATE_CREATED”. Below is the picture:

Microsoft Visio ERD Data Type Microsoft Access

Microsoft Visio 2010 – Ribbon Database Tab (Database Driver)


However, after exploring each ribbons in Microsoft Visio 2010, I found out a feature which is the Database Drivers that allows user to switch Databases. By switching to the database that you are working with, it populates with the data type it contains as well.

Microsoft Visio 2010 ERD Ribbons Database Driver

Microsoft Visio 2010 – Selecting Database Driver


Microsoft Visio 2010 has a list of database drivers such as MySQL, ODBC, IBM DB2, Oracle, Microsoft Access, and OLE. By default, it uses Microsoft Access Data Types. Since I am using MySQL as my database, I select MySQL from the list and click OK. Microsoft Visio 2010 will automatically update the drop down combo box.
Microsoft Visio ERD Database Drivers

Microsoft Visio 2010 Testing the New Data Types


Now, if you try to browse through the drop down combo box for your attribute, you will notice there these data types belongs to your database. It took me an hour to figure out all these things lol. Couldn’t find it inside Microsoft Visio Help File. Hope this helps you and other newbies like me encountering such problems.
Microsoft Visio ERD Data Type MySQL

Advertisements

Tags: ,

About ayumilove

I am Ayumilove, if you see some impersonators its not me.

4 responses to “Microsoft Visio 2010 ERD using Custom Data Types from Database Drivers MySQL Oracle Access IBM DB2 ODBC”

  1. kev says :

    Haha, I bet he confused MySQL with Microsoft SQL Server πŸ˜€

  2. Tom says :

    You are seriously on crack. MySQL is not in the list.

  3. Tony says :

    How were able to select MySQL from the list when its not in the list?

    How does one get mysql into the list?

  4. CamposMonster says :

    Ummmmmm…Where do you see MySql in the list of database drivers.

%d bloggers like this: