Thursday, September 15, 2016

Navicat Tips: How to create model from an existing database using Navicat Data Modeler?


Conditions:
  1.       Import tables through ODBC (through MariaDB in Linux version)
  2.       Use the “Microsoft Access Driver” to add a new data source


Windows:
Select “Tools” in the menu bar > Choose “Import from Database…” > Click “Manage Connection” > (Bottom left corner) “Manage Connection” > Select “ODBC” in “New Connection” from the dropdown list


Go to “Administrative Tools” in Control Panel > Select Database Sources
(select 32-bit ODBC Database Sources if using a 32-bit Navicat Data Modeler; select 64-bit ODBC Database Sources while using a 64-bit Navicat Data Modeler)



“User DSN” tab > Click “Add…” > Select “Microsoft Access Driver (*mdb) > Input Data Source Name in the setup window > Click “Select…” > Select database file > Click “OK” > Close the window when finish the settings 


Click “Manage Connection” > “New Connection” > Select “ODBC” > Set up the connection by inputting Connection Name > Select Data Source > Click “OK”


(You can also import connections that established in other Navicat Software to Navicat Data Modeler.)

Select the connection > Click “Manage Connection” > Choose “Import Connections from Navicat…” > Select connection(s) to import > Click “OK” 


Choose objects > Click “Start” to import 



Mac:
Select “import from Database” from “File” menu > Click “New Connection” > Choose “ODBC” 


Set up the connection > Click “OK”

(You can also import connections that established in other Navicat Software to Navicat Data Modeler.)

Click “Import Connection” > Select connection(s) to import > Click “OK” 


Select the connection > Click “Continue” > Choose object(s) to import > Click “Continue” > Click “Import” to start 



Linux:
Select “Tools” from menu bar > Choose “Import from Database…” > Click “Manage Connection” > Click “Manage Connection” button at the bottom left corner > Click “New Connection > Select “ODBC” > Set up the connection > Click “OK” 


(You can also import connections that established in other Navicat Software to Navicat Data Modeler.)

Click “Manage Connection” > Choose “Import Connections from Navicat…” > Select connection(s) to import > Click “OK” 



Select the connection > Choose object(s) to import > Click “start” to import 

Check out our other tutorials at bit.ly/navicatyoutube.

1 comment: