Flexible Database Management Solution

Multiple connections to multiple databases including local SQLite databases. Navicat lets you upgrade your data management capabilities by importing an over-full Excel dataset into a proper SQL table. Manages foreign keys and allows triggers to update multiple tables when you enter changes into a table or attempt to update a view.

For iKeithReview… simply drag a tab out of the window and a new window will be formed. This allows you to (for example) see the table structure next to the data table contents or to see two tables side-by-side on the screen.

Ive had no trouble exporting a multi-table database including thousands of rows with foreign key relationships and indices. WJNielsen, try Navicats customer support. I reported a problem with CSV exporting and they were highly responsive. The bug was fixed in the most recent update. As they continue add improvements to the product, it will only get stronger. Well done!

Mauiboy1959 about Navicat Premium Essentials