Free excel to mysql conversion software for mac

Calendar Conversion is an application designed to calculate dates past and future, with the ability to convert dates between the Gregorian, Julian, and Jewish calendar systems.
Calendar Conversion can also be used just as a multiple dates calendar.
It is especially useful for historical research, genealogies, date planning, etc.
Enhancements:
- Added printing of date windows. Fixed a cosmetic bug that prevented the Gregorian monthly calendar from ever displaying the twenty-ninth of February.

Requirements: Mac OS X 10.2 or later.

Perl Conversion Scripts is a collection of short scripts to convert data between different character encodings. Currently supported are Macintosh to ISO-8859-1, ISO to Mac, ISO to UTF-8, UTF-8 to ISO, Mac to UTF-8 and UTF-8 to Mac.They are very handy as BBEdit Perl Filters on Mac OS X where you can select some content in a text editor window and run the desired conversion script.

DBCopy Tool is an easy to use graphical interface to copy MySQL tables and databases between remote and local MySQL database servers. With the included PHP Tunnel interface DBCopy Tool even makes copies from MySQL tables and databases hosted with ISPs without a direct connection to the MySQL database server.

DBCopy Tool is desgined for web site and database developers and administrators to easily create copies of a database driven web sites for customer presentations and development. DBCopy Tool is available as free add-on for users of SQL4X Manager J (Professional and Enterprise Edition only), MySQL4X Manager (Professional Edition only) and eSuite4X.

Navicat for MySQL 8.1.5 brings you an effective solution for MySQL administration and development. This is an all-inclusive mysql front end provides a powerful graphical interface for databases management, development and maintenance. Easy installation and intuitive interface make it an irreplaceable tool for mysql on the web or your local desktop. Navicat supports all verions of MySQL and let you converts Access to MySQL, MS SQL to MySQL, Excel to MySQL, synchronizes and backups database in a snap through helpful wizards.

Major Features:

1. Latest MySQL Versions Support: Navicat for MySQL a powerful MySQL Database Server administration and development tool. Highlights of supported features:
   • Support of MySQL versions from 3.21 or above
   • Support of Unicode / Character Set
   • Support of MySQL Events, Views and Stored Procedures creation
   • Support of Triggers
   • Support of Foreign Keys
   • Support of Partition
2. Additional Connection Options
   • Support of SSH Tunnel: Establish a secure SSH session through SSH Tunneling in Navicat. Enjoy a strong authentication and secure encrypted communications between two hosts.
   • Support of HTTP Tunnel: Navicat comes with you HTTP Tunneling while your ISPs do not allow direct connections to their MySQL server but allows establishing HTTP connections. HTTP Tunneling is a method for connecting to a MySQL server that uses the same protocol (http://) and the same port (port 80) as a webserver does.
   • Provide auto-reconnection for MySQL server: With the option "Keepalive Interval", you can keep connection alive with the server by pinging it.
3. Comprehensive Management of MySQL objects
   • Create, edit and drop table's fields, indices, foreign keys and triggers: With Table Designer the basic Navicat for MySQL tool for working with tables, you can create, edit and drop table's fields, indices, foreign keys, and much more.
   • SQL Preview: The SQL Preview area shows you SQL representation of the oracle objects you are creating. This ability allows you to preview SQL before execution.
   • Dump object definition as sql file: Backup object definition and data with ease by dumping as sql file.
   • View Database / Table Structure: Present the database / table definition by printing their structures in Navicat. Understand the respective object structure fully at a glance.
4. Diversified Import and Export Competence
   • Import data from ODBC: You can import data from ODBC after setting up a data source connection. All available tables will be included if connection success. Just simply choose the tables you wish to import or specify a query using Add Query button.
   • Import data from different file formats: XLS, CSV, TXT, DBF and XML: Import Wizard allows you to import data into a table from diverse format. On top of that, you can save your settings as an import profile for setting schedule.
   • Export data to different file formats: XLS, TXT, CSV, DBF and XML: Likewise, Export Wizard allows you to export data into various format. Save your settings as an export profile for setting schedule.
   • Export data and create records as INSERT statements in sql file: During Data Transfer, you can choose to export data as sql file with record options like complete insert statements / extended insert statements etc.
5. Powerful Data Manipulation Tools
   • Form View: Manipulate the current record with Form View. Enjoy a clear display of field name and its value with focus on current record.
   • Support of Foreign Key Data Selection: With the GUI tool Foreign Key Data Selection, you can locate the foreign key values from the reference table. Stop shifting the view to a master table to look for the available values!
   • Data and Structure Synchronization: Navicat for MySQL allows you to transfer data from one MySQL database to another with detailed analytical process. Likewise, you can compare and modify the table structures. For both Data and Structure Synchronization, the target database can be on the same server as the source database or on another MySQL server.
   • Support of Data Transfer between local / remote MySQL databases: Transfer tables/views/stored procedures/events from one MySQL database to another MySQL database, or to a plain text file.
   • Support of Backup and Restore MySQL databases: Regular backup on database is important to users. Backup/restore all tables and records, views, stored procedures and events for your MySQL database using Navicat. You can also schedule backups between databases.
   • Create Schedule for Backup, Import / Export, Data Transfer, Saved Queries and Data Synchronization: Create a batch job for setting schedule to execute at one or more regular intervals, beginning and ending at a specific date and time. Batch job can be created for Query, Backup, Data Transfer, Data Synchronization, Import and Export.
   • Send notification e-mail and attachment for schedule task: Generate notification e-mails with attach exported files to recipients you specify, connecting them to the latest schedule information. Read directly through your email account on the results returned from a schedule.
6. Powerful Security Management
   • Visual User Manager: Navicat provides users a visual tool for user management. You can easily add, duplicate, delete users, and edit global user privileges, and grant privileges on the selected databases, tables/views, fields and stored procedures/functions.
7. Well-Designed Visual Builder / Editor
   • Visual Query / View Builder: Visual Query / View Builder which is divided into two portions: the upper Graphical View, and the lower Syntax View, allows you to create and edit queries / views visually without knowledge of SQL.
   • Query Editor: It allows you to create and edit SQL text for a query, prepare and execute selected queries.
   • Support of Parameter Query: Set query parameters to add variable values to a query each time you run it.
   • Code-Completion for Query, View, Stored Procedure and Event: Experience a quick way in constructing SQL statements in Query Editor, View, Stored Procedure and Event with the Code-completion feature. Whether you want to select available properties of database objects or SQL keywords, all it takes is a pick from the drop-down list.
8. More great features
   • Virtual Grouping: Have a better organization over objects in Navicat. You can categorize objects into groups with the Virtual Grouping feature. Virtual Grouping can be applied on Connection, Table, View, Stored Procedure, Event, Query, Backup and Schedule.
   • Server Monitor: Select the servers that you want to monitor by checking them in the checklist box of the Server Monitor Window. Click on either Process List, Variables or Status icon to show and/or modify the properties of MySQL servers.
   • SQL Console: To use a command-line interface, you can open SQL Console in Navicat. It provides you an interactive text-based screen to query input and result output from database.
   • Tabbed Windows: Customize your window behaviour style. Navicat supports you of dragging windows in and out of the tabbed windows.

Enhancements:

• Improvements:
• • Improved compatibility to some ODBC drivers for Import Wizard.
• Bug Fixes:
• • Incorrect use of hexadecimal format in MySQL data types other than BLOB in Data Transfer.
  • Data grid was unable to be opened properly when some kind of text were displayed.
  • Removed some internal SQL run by Navicat in Query Viewer.
  • Unable to change the default value of an existing field from NULL to other values in Table Designer.
    

Requirements

• Mac OS X 10.4 Tiger or 10.5 Leopard

MySQL Connector/J is a native Java driver that converts JDBC (Java Database Connectivity) calls into the network protocol used by the MySQL database.

MySQL Connector/J is a tool that helps developers working with the Java programming language easily build programs and applets that interact with MySQL and connect all corporate data, even in a heterogeneous environment.

MySQL Connector/J is a Type IV JDBC driver and has a complete JDBC feature set that supports the capabilities of MySQL.

The latest production version of the driver is now 50-100 percent faster in most situations than the previous version. It also creates fewer transient objects than before, leading to better performance and even more stability.

The driver now also supports "streaming" result sets, which allows users to retrieve large numbers of rows without using a large memory buffer. With newly added large-packet protocol support, the driver can send rows and BLOBs up to 2 gigabytes in size.

New features from the JDBC-3.0 API in the latest production version of MySQL Connector/J include getGeneratedKeys which allows users to retrieve auto-increment fields in a non-database-specific way.

Auto-increment fields now work with object-relational mapping tools, as well as Enterprise Java Beans (EJB) servers with Container Managed Persistence (CMP) that support JDBC-3.0.

The development version is being refactored to support new features in conjunction with version 4.1 of the MySQL database server, including server-side prepared statements and improved handling of multiple simultaneous character sets, including Unicode in the UCS2 and UTF8 encodings.