Free mssql software for windows

ReadSQL 1.0 offers an innovative, versatile command line SQL analyze application. Easy to use support MSSQL, Access, and MYSQL. For example: C:>ReadSQL.exe -help ABOUT : Copy right infomation CLOSE : Close database CLS : Clear screen COUNT : Get records count in current recordset DB : List databases DEMO : Demo how to use this tools H : Help OPEN : Open database by connection string Q : Quit RECORD : Display current record in current recordset SQL : Execute a SQL command T : Move to next record and display it TABLE : Show all tables in current db VER : Get MDAC version.

Provides an easy to use Java based user interface frontend for viewing, adding, editing, or deleting entries in MySQL MyJSQLView provides an easy to use Java based user interface frontend for viewing, adding, editing, or deleting entries in a MySQL database.
A query frame allows the building of complex SELECT SQL statements.
The application will allow you to easily sort, search, and import/export of table data.
All tables and fields are available for access in the selected database. MyJSQLView only needs two other pieces of code, the JRE, Java Runtime, and MySQL Connector/J. MySQL Connector/J provides the driver interface between the Java SQL statements, and the MySQL database.
The database driver for Java is not limited to MySQL and can now through the introduction of the new login interface and its Connetion Manager be used to access other databases like DB2, Oracle, and MSSQL
Main features:
- User Connection Preferences Saving/Managing.
- User Preferences Summary Table Column Selection.
- Access to All Tables in Database During Session.
- Viewing, Adding, Editing, and Deleting All Table Fields.
- Supports All MySQL Data Types, Including Blobs.
- Data Type Checking During Adding or Updates.
- Support for All Table Types, Including Transaction Locking.
- Printing of Summary Table Data, Screen View.
- Export of CSV Summary or Complete Table Data.
- Export of SQL Summary or Complete Table Structure/Data.
- Export of SQL Current Open Database Scheme
- Import of SQL Statement File.
- Query Frame for Building Complex SQL Statements.
- Simple Easy to Use Interface.
- Table Sorting and Searching.
System requirements:
- PentiumAMD 350Mhz based PC or compatible.
- Minimum 64 Megabytes of RAM
- Less Than 3 Megabytes of hard disk space
- Mouse
- Java

Navicat (MySQL Manager) version 8.x is a MySQL database management tool, which can convert XML, CSV, MS Excel, MS Access, and popular data formats to MySQL databases, eliminating time-consuming data entry and the errors that accompany it.

Other useful major features include import and export wizard, Unicode support, HTTP/SSH Tunnel, batch job scheduling, data synchronization, data transfer, visual query builder, and visual report builder. Navicat features importing data from ODBC and batch job scheduling.

Major Features:

1. MySQL Objects Management
   • Support MySQL servers 3.21 or above
   • Create / drop databases
   • Support all MySQL objects: tables, views, stored procedures/functions and events
   • Support all subobjects: fields, indices, foreign keys and triggers
   • Support of character set and unicode
2. Connection Management and Navigation
   • Multiple local/remote MySQL server connections
   • Connection to MySQL Server through SSH
   • Connection to MySQL Server through HTTP
   • Support SSL secure connection
   • Keep connection alive
   • Backup connection informations
   • Customize selected databases to work with
3. Data Viewer and Editor
   • Grid view
   • Form view
   • Text, Hex and BLOB viewer/editor
   • Copying and pasting selected records
   • Customize display formats
   • Incremental search, sorting and formatting table grid
   • Support of raw mode edit: apply MySQL built-in function
   • Support of foreign key data selection: locate the available values from the reference table
   • Filtering Records
   • Ability to set number of records showing on each page
4. SQL Processing
   • Visual query/view builder to facilitate the process of building complicated queries
   • Ability to create parameter queries
   • Multiple SQL editors with syntax highlighted feature
   • Code completion for SQL editors
   • Ability to preview SQL before execution
   • SQL console
5. Diversified Import and Export Competence
   • Importing data from ODBC: MSSQL, Oracle etc
   • Importing data from MS Excel
   • Importing data from MS Access
   • Importing data from other file formats : TXT, CSV, XML, DBF etc
   • Exporting data to MS Excel
   • Exporting data to MS Access
   • Exporting data to HTML and PDF
   • Exporting data to most popular formats: TXT, CSV, XML, DBF etc
6. Other Data Manipulation Tools
   • Data transfer
   • Transfering data to SQL script as INSERT statement
   • Data synchronization
   • Structure synchronization
7. Backup/Restore
   • Backing up/restoring database
   • Restoring database with chosen database objects
   • Converting backup file into SQL script
   • Backing up database/table to SQL script
   • Executing SQL script
8. Schedule for Batch Job
   • Ability to set schedule on backup, query execution, import/export, data transfer and data synchronization
   • Schedule report printing
   • Schedule to print report to files: PDF, Excel, HTML etc
   • Sending notification e-mail for schedule task
9. Server Security and Maintenance Services
   • Visual user manager to administer users and privileges
   • Ability to duplicate user
   • Analyzing, checking, optimizing and repairing tables
   • Server Monitor to view and change system variables, to view server status information
10. Report Management Tools
    • Report Builder
    • Report Viewer
11. Other Useful Features
    • Duplicate/empty/ truncate tables
    • Create table/view shortcut on desktop
    • Print database/table Structure
    • Support of docking/tab windows
    • Support of virtual grouping: provide logical organization over connections and objects
    • Ability to run profile from command line
    • Log files: keep track on the actions have been performed in Navicat

Enhancements:

1. Added keyboard interactive authentication for SSH.
2. Adjusted the AutoFill from picklist behavior for Grid View.
3. Bug Fixes:
   • Fixed export excel spreadsheet with datetime was set to 0.
   • Fixed wrongly treat empty string as null.
   • Fixed access violation when select BLOB/TEXT issue.
   • Disable KeepAliveTimer before executing SQL.

WareSeeker Editor