Apex SQL Diff is a server based, high speed database comparison tool that will analyze the differences in tables, procedures, views, users etc between two Microsoft? SQL Server? databases in seconds. You will be able to visually observe the differences in the object's script shown side by side. Apex SQL Diff tool also allows you to programmatically synchronize the databases based on the differential analysis.
Apex SQL Clean tool looks for and deletes unreferenced and unused Database objects like tables, views and procedures. If database object bloat is the problem, Apex SQL Apex SQL Clean is the solution. Your database may have many stored procedures, tables and views that aren't being used anymore but unless you determine which of your SQL objects fall into this category you will be stuck with them forever.
Manage MSDE/SQL databases via an intuitive graphical interface and do all of the common operations that a typical deployment of MSDE/SQL would entail and much more besides. Add, edit and delete Databases, Tables, Views, Users, Rules, SP's & more. It has a Transact SQL screen and in-built web updating to keep users on the most recent version. MSDE Manager has in built help. Back up, restore, attach, detach, and shrink databases. Schedule jobs.
Apex SQL Edit is a complete development, editing and deployment environment for SQL Server Developers. Apex SQL Edit provides Visual Source Safe Integration, Intellisense and powerful features not found on other SQL Editors. Apex SQL Edit offers many new features including object notes, context sensitive options while editing such a What is?and Open of stored procedures as well as results pane that allows grouping and filtering...
Loads data into Oracle ,SQL Server, ODBC Databases (Datawarehouses) from flat files, cross tables or ODBC datasources. Very fast and reliable. Uses naitive API (OCI API,BCP API,ODBC API) Capable of performing calculation during import, may also execute SQL statemts before and after import. Integrated expression builder, comprehensive error log, rejected records file. Source Data Filtering
Imports data into Oracle ,SQL Server, ODBC Databases (Datawarehouses) from flat files or ODBC datasources. Very fast and reliable. Uses naitive API. Repository: MS Access, Oracle, MS Sql Server, Interbase, MySql, PostgreSQL Also:Easy Repository switching, Data Preview, Mapping editor, Exports, SQL scripts editor, Packages editor, Integrated Scheduler, Logging, Lookups, Email Notifications, File Operations, Check Files, Compare Files
Apex SQL Log is a powerful SQL database auditing tool that analyzes SQL Server's own Transaction Log to display information on data and structural changes. Since Apex SQL Log reads the Transaction Log, no database overhead is required and audits can be done on changes made even before the SQL log tool was installed. Currently Apex SQL Log reads database back-up files and processes them into readable information.
DB SynchroComp compares two SQL Server databases, determines differences between them, and generates the script that will change the target database structure to match the source database structure. After you execute the synchronization script, two databases will have the same structure, and existing data in the target database will remain intact.
Apex SQL Doc is a powerful tool to document your sql server database into HTML help Documentation. Apex SQL Doc's wizard approach walks you through a series of steps that allow you to set options and otherwise customize your Documentation file. With full command line support, Apex SQL Doc can be set to run on a schedule, over night etc Version 2.0 will quickly follow our first 1.0 release and will include many new features.
Powerful easy to use tool syncs data and tables between databases. Converts between different database types Move from MS SQL, MS SQL Sever Express, MS Access, MySQL, Excel, Paradox, Foxpro, DBase to mySQL, MS SQL, MS SQL Express or MS Access. Creates table and indexes automatically. You can clone and design new tables. Maps columns of unlike tables. Imports/Exports SQL Scripts, XML, Excel, CSV and HTML. Reports on table schema.