SQL Admin Studio

Database Management Software for Developers & DBAs

[Windows 10 / Windows Server 2012 R2 - 2019 64-bit Installer]
Data Synchronisation Studio Screenshot

What is SQL Admin Studio ?

SQL Admin Studio is a powerful SQL Database Design & Management Tool designed for Software Developers & Database Administrators. Giving you fast access to your databases without the bloat.
Connect to SQL Server, MS Access, MySQL and PostgreSql. SQL Admin Studio makes managing your databases very simple.
The dynamic Text Editor includes intellisense to help you create and edit your scripts, including any stored procedures. You can drag and drop objects into the script window to prevent mis-spellings and ensure you are targeting the right object. When previewing table data you can make edits to the data in specific cells right there and then without the need for any scripts.
Compare schemas or simply make changes to a single table schema, nothing is too big or small for SQL Admin Studio.

Schema Comparison

Quickly compare schemas between databases to find difference that were made. You can then apply any changes by selecting the tables to apply them to and clicking Synchronise. SQL Admin Studio will then do all the work for you and make the updates.

If you want to customise the schema changes then generate the change script. This will open the full SQL statement and you can edit it as you need to.

SQL Admin Schema Compare
SQL Admin Data Compare

Data Compare

Being able to quickly compare data between tables is invaluable, just set your source and target database, show the tables and then compare.

The differences are then split out into each table so your can view the data changes before applying them to the database. You can also exclude certain tables from the sync.

SQL Admin Studio Features

Connect to any SQL Server, MySQL, Access and PostgreSQL Databases

  • Export Data

    SQL Admin Studio provides functions to simply export your data to CSV File, Excel File, XML File and SQL Script file. All this is available from the mini-toolbar on the results window. The result from any SQL Query can be exported into these file types in a matter of seconds.

  • Import Data

    Import data across Servers to make simple backups of remote databases. Import Microsoft Access Databases into SQL Server or just create a copy of an existing database. You can also import CSV, TAB, Excel and XML datasets.

  • Preview Data

    Preview data within your tables and even preview data before applying changes in the import and comparison tools.

  • Compare SQL Database Schemas

    Can't remember what changes you made to your database schema? SQL Admin Studio can compare 2 SQL Server database schemas to locate the differences and can even script the differences without having to drop all objects and re-create the database from a create script.

  • Compare SQL Database Data

    Simply generate SQL Data Change scripts by comparing the database between databases. Changes can then be executed directly within a transaction or scripted to be applied manually later.

  • User Code Generation Templates

    SQL Admin Studio has a great feature that allows you to write a template that can generate any kind of ASCII Text from the database schema. You can use this to create prototype stored procedures, Data Access Layer Code or just to document the database. This is a great time saving feature of SQL Admin Studio and these Templates can be designed in either VB.NET or C#.

  • Execute Queries

    With the ability to generate scripts from templates or even create a new script from scratch, you can execute AD-Hoc queries as and when you need to.

    To make script writing easier you can also drag and drop objects from the database explorer to make use of them within your code.