 |
Sync Database is an easy solution to synchronize schema of mySQL databases. When you alter database, add or change columns, indices or constraints, sync is done in an quick and painless process and enables you to change the structure of your older database to its newest version while preserving its data.
1. Select source database or load an SQL script.
2. Select target database (you can also create it using builtin script editor)
3. Press Synchronize
Sync Database synchronizes column, index, constraint information. Conversion between table types is supported, as well as transactions.
Typical Sync Database use:
A software developer constantly tweaks application and database design. When a new version is is released, you have to apply changes to your customers' existing database so new code can work for them, too. If you have a clients with one version and release a new one, you have to run a script to the underlying database. If you have 5 different versions spread, you need to have 5 different scripts or apply a difference scripts from version 1 to 2, from 2 to 3 etc. Why not going the simpler way? Using this efficient standalone app (all is contained in a single executable), you can be assured that sync will be done quickly and easily. No need to remember your versions. You provide the latest (reference) SQL script or database, choose your target, and run. The process is done in seconds!
mysql database synchronization schema ddl versions versioning sync database easy solution
|
 |
What is SQLDBCompare?
SQLDBCompare is the powerful database schema/data comparison and synchronization tool for SQL Server database development projects. SQLDBCompare integrates with SQL Server, providing an effective and effortless database schema comparison for individuals and project teams to compare the SQL Server databases on either the same server or different servers. It also provides the functionality for developers to synchronize the SQL Server objects from one database to another.
With SQLDBCompare, users can compare database structure/schema/table records over database objects (tables, stored procedures, user defined functions, views, triggers, indexes/keys, and constraints) in two databases. User can view the results at a high-level, or drill down to the fine grains of every detail for each difference. The users can synchronize each database object by copying the object (structure) from one database to another.
Who needs SQLDBCompare?
Any project team or DBA's managing multiple copies of the same database on SQL Server. If you have various database environments such as development, test, staging, and production, or distributed SQL Server databases where schema/code updates to each database can occur at a different time, SQLDBCompare is the right tool that you have been looking for!
sqldbcompare sql server tool schema compare synchronize database ms sql sql compare sql db compare
|
 |
web-based MS SQL Server(MSDE)2000 client tool, query analyzer and dba utility to design, create, query, backup, manage and monitor database from a web browser. Pure ASP script, no installation needed. Freeware for Educational and Personal usage.
For DBA ( Database Admin )
o Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules.
o Monitor connections, locks and performance of SQL server. Kill bad process.
o Administrate security for server logins (Windows and SQL accounts), database users and roles.
o Assign permission to user(s), role(s), object(s). Support column level permission.
o Backup, Restore and Repair database. Compress Transaction Log.
For Developer ( Database application )
o Color-coded Editor for View, Stored Procedure, User function, Inline function and Trigger.
o Create and modify database, table, index, constraint (default, check and foreign key).
o Automatic Duplication and Orphanage check.
o Database-wise search for a specific value (number, datetime or text format).
o Database-wise search for a specific object (table, view, stored procedure, user / inline function and trigger).
o Automatic database documentation / dictionary.
o Automatic Parent / Child Key tracking and Object Dependency tracking.
For End User ( Specific permission might required from DBA )
o Query any data with a color-coded SQL panel.
o Edit table data in a spreadsheet-like Editor. (with row/column copy/paste/reset, fill down feature)
o WYSIWYG Editor to edit and store large plain/HTML document in the database.
o Create user table, view, function, trigger, index and constraint.
o Execute any SQL script (multiple, compound query), MS DOS command.
o Save and open SQL script from local disk.
For all
o Secure login from Internet as a Window.
o Streamlined query process for large query (return millions of rows without freeze).
o Virtual MS DOS prompt window.
o Current running Query cancellation.
web based sql msde dba tool web-based ms sql server msde
|
 |
SQLMerger enables you to compare and merge data from two databases visually and automatically. All the changes are made via a SQL script automatically created and collected through time. SQLMerger makes it very easy to upgrade and edit contents in any database. The tool also contains a number of other toolkits to make database content editing and browsing much more comfortable than you are probably used to using the tools from the database vendor.
merge data sql software comparison diff free database download record table
|
 |
1. IBLogScript - scripting tool for replication and cancel of data changes for Interbase.
IBLogScript is intended for IBExpert (v.2.2.0.4 or later) users working with IBExpert data changes log.
(IBExpert log machine is a set of tables and triggers for data changes tracing. IBExpert automatically generates this set)
If You already work with this convenient capacity, but need a tool for data changes cancel or transference from one sister database to another, IBLogScript will help You.
IBLogScript creates SQL script for replication or cancelling of data changes logged by IBExpert (in tables IBE$LOG_TABLES, IBE$LOG_FIELDS etc.)
2. User's directions
Just specify database file name, user name, password and script type (reproducing - canceling) and execute (F9), then save resulting script in file or copy it to clipboard.
To show in script date and user info (who and when made this data change) set checkbox "Include date and user comments" to true.
You can also restrict period of data changes that will be included in resulting script by specifying right period dates.
3. Known limitations
BLOB fields updating is not supported yet.
4. Development plans
BLOB fields updating realization is planned by means of XML-based data changes log transference.
interbase firebird ibexpert log script data changes ibe-log_tables ibe-log_fields scripting tool
|
 |
SQLExecMS is a lightweight but powerful tool for Microsoft® SQL Server DBAs and database developers.It supports MS SQL Server 7, 2000 and MSDE. Unique all-in-one interface for management, tuning up, development, deployment and data manipulation. Ultimate tool for MSDE developers and administrators. SQLExecMS doesn't require any additional installation, just 'drop and run', that is why it is almost perfect to be built in to your DB product. SQLExecMS doesn't use DMO or any other ActiveX components, this is one of the reasons why it works much faster than other similar tools. Finally, this application has been created based on long experience of development and of support DB systems.
Llist of features divided by categories:
-for DBA - Monitor active connections, oldest transactions and vital SQL server performance counters;Check utilization of proc cache;Watch locks; Review space used by DB files, tables and indexes; Manage DB file and filegroups;Turn on and off trace flags;Manage scheduled jobs; Change SQL server and database options;Backup and restore databases; Analyze fragmentation of tables; Analyze wait statistics; Manage indexes and analyze the selectivity of an index; Attach/Detach databases; Review error logs of SQL server; Manage extended stored procedures; Manage logins and users;Use bulk insert.
-for Developers-Execute any T-SQL statements;Review estimated execution plan;Find substring in objects DDL; Use SQL history of your sql statements; Use quick reference and assistant; Easily view the table and view data;Manage triggers;Manage indexes;Compare scripts of two databases; Review objects dependencies in tree-like view; Review object properties; Find an object by its ID;Generate SQL script for your DB.
And many other handy features....
ms sql msde t-sql query analyzer enterprise manager sql tool dba unique all-in-one interface
|
 |
myLittleAdmin is a web-based MS SQL and MSDE database administration tool.
This new version of myLittleAdmin has been completely re-written. It offers a new skinnable interface and a lot of great new features, such as user levels, multi-databases support or SQL script generation. It is now possible to manage all objects of your server and databases including tables, indexes, foreign keys, triggers, constraints, views, stored procedures, users, roles, rules, defaults, udt, udf, logins.
Windows platform webhosting companies will appreciate to integrate myLittleAdmin as a part of their hosting product offering. Developers will appreciate its speed and its easy use. Webmasters will appreciate that such a great product does not need installation of any component or DLL on the server.
myLittleAdmin is provided in source code format (ASP and VBScript).
sql server msde asp web-based administration mylittleadmin web-based ms sql msde database
|
 |
Visually build complete SQL scripts - other query tools only build single SQL queries. Introduce massive time savings and reduce debugging, syntax and logic errors. Easy to use. Build complex SQL scripts without typing any SQL. Incredibly versatile, flexible and extendible - users have complete control over the SQL that is generated. Suitable for DBAs and developers of any expertise. Supports Oracle, SQL Server, MySQL and Access.
sql software sql tool query builder query tool sql builder sql script sql scripts script builder scripting tool script product query software
|
 |
DBExplorer is a powerful database utility that allows you to compare any two databases and report the structural and/or data differences between them. It then enables you to synchronize the differences. DBExplorer supports any OLE DB or ODBC compliant database which includes all the mainstream databases including MS SQL Server, Oracle, DB2, Access etc.
Database Catalog
Browse a databases schema and/or data. Provides a built in reporting tool and an export to file feature so you can document the database schema and records. An SQL query wizard allows you to select particular columns and filter specific records. It can also generate SQL DDL scripts to reproduce or record the database structure.
Compare Schema
Compare the structure or metadata between two versions of a database. The objects compared include tables, columns, views, procedures, indexes and foreign and primary keys constraints. Once the comparison is complete DBExplorer presents a detailed on-screen summary. From here DBExplorer can automatically generate the appropriate SQL statements (ie, SQL DDL - Data Definition Language) to bring the database up to date. Depending on the differences detected this may be a "CREATE TABLE/VIEW/PROCEDURE" or a "ALTER TABLE ADD COLUMN?" type statement. These generated SQL statement can be saved to a separate SQL script file for later execution or applied directly.
The entire comparison results can also be saved to a document file or printed out as a HTML report.
Compare Data
DBExplorer uses a sophisticated internal hashing algorithm to report the differences between the data stored in two databases. The databases to compare do not have to reside on the same machine or even in the same RDBM system. Comparison includes records that are identical, duplicated or having the same data but different keys as well as being present in only one of the databases. Once the comparison is complete you can choose to synchronise selected records to one or other database.
database utility compare database view database database difference schema metadata compare tables compare data compare records synchronise database compare
|
 |
ODBCView is a free SQL query tool that allows you to view and export data from any OBDC compliant database. Connect to an ODBC data source and enter a SQL statement to execute. Any resulting data is displayed on a read-only grid or it can be exported to a external CSV or HTML report file. Any valid SQL statement can be executed including UPDATE, DELETE and calls to database procedures. You can also run it from the command line to open a data source, execute a sql query from a sql script file and export the results to an external CSV or HTML file. The program is completely standalone with no other dependent DLL's other than standard Window system DLL's.
This program is provided free of charge by SLIK Software Ltd as a gesture of goodwill and to encourge users to visit our web site (www.slik.co.nz) for other database related products including DBExplorer (compare and synchronise databases) and Standard Legacy Interface Kit a middleware / automation application that supports column mappings, e-mail, FTP, EDI, XML and 20 other data interfacing operations.
database odbc sql sql query tool view data export data odbcview free sql query tool
|
|
|
