Access is a Microsoft database, porting away from it may be a nightmare.
Aug 12, 2018 Lucidchart is cloud-based and collaborative diagram software. Lucidchart helps your team create not only database diagram but also flowcharts, process maps, UML models, org charts. On any device across the platform you already use. Free plan comes with a limit of 3 diagrams and 60 objects per diagram. Good experience and collaborative. Mar 20, 2017 Claris (Apple's software division) bought FileMaker back in 1985, they spun it off as a subsidiary in 1998 so they could gain traction in the Windows market. If you want a basic database try EagleData or for more features LibreOffice, both are free. SQLite is another open-source free-of-cost SQL engine. But as the name suggests, it is aimed at relatively small simple purposes. Apple bundles SQLite with both Mac OS X and iOS. H2 Database Engine. If you are savvy with Java, you might consider the H2 Database Engine. Simple to get started with. SQL Database Pro for Mac relates to Developer Tools. The most popular versions among the program users are 2.2, 2.1 and 1.2. This software for Mac OS X was originally designed by Impact Financials, Inc. This app is suitable for Mac OS X 10.8 or later. Our built-in antivirus checked this Mac download and rated it as virus free. IDatabase is the Mac app that simplifies the creation of databases, inventories, collections and lists of items. IDatabase is the best there is for those who want to manage, store and quickly find any information for their passions and for everyday work.
First, tell us why you are wanting to move to a different database platform. (Need the end goal to figure out how to do it)
What compliance standards do you have to adhere to? PCI, HIPAA, etc.
What are ALL of the platforms you need the database to work on?
PC/Mac/Android/iPhone/WindowsPhone/Web?
I highly recommend posting your question on the SpiceWorks forums as this is something IT specialists know what to do and how to go about it. I am a member there and will offer any guidance as well. http://community.spiceworks.com/
Lastly, Apple owns FileMaker which is a Mac/PC-friendly database system. While waiting for the IT pros to assist with a plan, call the team at Filemaker and see what they can do for you. http://www.filemaker.com/
Jul 2, 2015 12:55 PM
A database schema is the blueprints of your database, it represents the description of a database structure, data types, and the constraints on the database. And designing database schemas is one of the very first and important steps to start developing any software/website.
To help you determine the right tool for you to design database schema diagrams, we've curated a list of 5 of the best free online tools to do it.
Top 5 Free Database Diagram (ERD) Design Tools
dbdiagram.io
Pricing: Free with unlimited objects and diagrams
- dbdiagram.io is a quick and simple database designer to help you draw your database diagrams using their own Domain-specific language (DSL).
- They have a simple language to define, you can easily edit/copy without leaving keyboard
- They focus exclusively on drawing database relationship diagrams
- Allow you to save and share your diagrams online.
- Designed for developers, DBA, data analysts
- Their UI looks simple and neat, with pretty diagrams.
Draw.io
Pricing: Free for web-based usage, paid for Atlassian (Confluence/JIRA) apps.
- Draw.io is a free online diagram software for making flowcharts, process diagrams, etc.
- Allows different types of charts like flowcharts, org charts, UML, ER and network diagrams.
- Allows saving your diagrams to cloud storage services like GDrive, Dropbox and OneDrive, or to your own computer
- Visual interfaces not as nice as lucidchart.
Lucidchart
Pricing: Free with limited objects, $4.95-$20/month
- Lucidchart is cloud-based and collaborative diagram software. Lucidchart helps your team create not only database diagram but also flowcharts, process maps, UML models, org charts,.. on any device across the platform you already use.
- Free plan comes with a limit of 3 diagrams and 60 objects per diagram
- Good experience and collaborative
- Integrated with G Suite, Microsoft Office...
- Good if you are more of a designer and want drag-and-drop interface
SQLDBM
Pricing: Free (Beta) with unlimited diagrams and objects
Best Database Software For Mac
- SqlDBM offers you an easy, convenient way to design your database absolutely anywhere on any browser, working away without need for any extra database engine or database modelling tools or apps.
- They incorporates any needed database rules and objects such as database keys, schemas, indexes, column constraints and relationships
- Only support MySQL and MS SQL
- Support Forward Engineering and Reverse Engineering
- 100% drag and drop UI
- Support version history
QuickDBD
Free Mac Database Software
Pricing: free for 1 public diagram and 10 tables, plans at $14/month for unlimited tables and private diagrams.
- QuickDBD helps you quickly draw a diagram using just text input.
- It quickly captures ideas, and you can draw schema diagrams using only the keyboard.
- Support exporting to SQL, PDF and Word
Sign up for our BI newsletter
Insights from practitioners around the globe.
In your inbox. Every week.
In your inbox. Every week.
No spam, ever. We respect your email privacy. Unsubscribe anytime.