ADEPT SQL TOOLS LAUNCHES ADEPTSQL DIFF.Adept SQL SQL in full Structured Query Language. Computer programming language used for retrieving records or parts of records in databases and performing various calculations before displaying the results. Tools has launched AdeptSQL Diff, a Windows application A program that is written to run under Microsoft's Windows operating system. Such applications typically run under all 32-bit versions of Windows, but earlier applications might also run under the 16-bit versions (Windows 3.x) as well. See Windows. that makes it easy to visually compare two MS SQL Server See Microsoft SQL Server. databases, then produce and execute synchronization SQL scripts for a chosen part or for the whole schema. The program scans both databases and displays the combined schema tree view, with all differences color-marked. AdeptSQL Diff is very fast and easy to operate. Navigating through the database schema The definition of a database. It defines the structure and content in each data element within the structure. Schemas are often designed with visual modeling tools that automatically create the SQL code necessary to define the table structures. See subschema and XML schema. tree, you can see SQL definitions for individual objects (tables, view, stored procedures, etc) compared side-by-side in the larger panel to the right of the schema tree. You can produce difference scripts for any chosen part or for the whole schema. The schema matching engine generates effective update SQL for any schema difference you need to synchronize, trying to preserve the table data whenever possible. The generated scripts are displayed in a separate debugger-style popup window where you can edit them, execute them either uninterrupted or step-by-step, set breakpoints, turn on transactions, and rollback on errors. Even if you have only one database to work with, the drag and drop A graphical user interface (GUI) capability that lets you perform operations by moving the icon of an object with the mouse into another window or onto another icon. For example, files can be copied or moved by dragging them from one folder to another. scripting (you simply drag one or more schema items to any text editor supporting OLE drag and drop) together with very flexible scripting options makes AdeptSQL Diff a perfect tool to reverse-engineer your database schema. Currently, versions for MS SQL Server and Interbase are available. Support for other SQL databases is planned. AdeptSQL Diff runs under Windows 98/Me/NT4/2000/XP. Prices begin at $240(US) for a personal license. LAN (Local Area Network) A communications network that serves users within a confined geographical area. The "clients" are the user's workstations typically running Windows, although Mac and Linux clients are also used. packs and site licenses are available. For more information, visit http://www.adeptsql.com/ or write to info@adeptsql.com |
|
||||||||||||||||||
Printer friendly
Cite/link
Email
Feedback
Reader Opinion