Home > Development > Other > Apex SQL Clean

Apex SQL Clean

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.

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 tool 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 objects fall into this category you will be stuck with them forever. Apex SQL Clean will analyze a client whether it be VB, ASP, Delphi etc to determine what SQL objects are actually being used and what objects aren't. It will also analyze the database itself to see what internal references exist among SQL objects. Based on the Apex SQL Clean analysis it will generate a file of SQL drop statements to Clean your database of these useless objects. Features - Support for tables, views, procedures, rules, defaults, triggers, user defined datatypes, user defined functions and file dependencies - Interface shows Object dependencies and objects with dependencies to it. - Graphical display of number of unreferenced objects. - DDL script for object colorizes referenced object names to allow you to visual spot the dependencies. - Users have the ability to create file search pattern to analyze all files of a particular language or project (i.e .frm, .asp, .pas, .cls) - The file processing engine is recursive - simply point to a directory and it will search all subdirectories for files that match the search pattern you create. - Automatic drop statement creation. Interface shows whether file is referenced, has references and the number of each. Simply clicking on the object will display all references. - Double clicking on any object will script it. - Interface supports grouping/ungrouping by object type.

Apex SQL Clean Description

Author:
Version: 3.1
Release: 2005-09-22
Platform: WinXP,WinNT 3.x,WinNT 4.x,Windows2000
File size: 3.23 MB
Price: $149
Install: Install and Uninstall
Rating: Not rated
Click here to free download Apex SQL Clean

Other software from same author

See related software

Export Table to SQL for Oracle
Export Table to SQL script for Oracle helps to save table's data as a set of INSERT SQL statements and optional CREATE TABLE statement. Predefined or custom separators like ';' and a few export options make this tool flexible. The program has easy to learn and to use wizard interface. This handy utility helps database developers and database administrators to create table-based SQL script within seconds. All Oracle versions are supported.
MSSQL to MySQL Converter
Microsoft SQL server to MySQL converter software converts selected groups of tables in a more efficient manner. Utility migrates all table rows columns attributes primary key foreign key unique key constraints. Application tool supports all major versions of MSSQL and provides safe data conversion & data integrity. Conversion software provides full Unicode architecture supports & runs under windows XP, ME, NT, 2000, 98 and 2003 operating system.
Tidycode Pl/Sql Formatter
This software allows you to tidy, beautify or format your Pl/Sql code in a batch file or Dos prompt.In other words, it is a command line tool that can be built in your programming environment. It can be used in most free or commercial editors/IDEs.There is also a tool Experimenter which provides an alternative user interface to the formatter. the command line switches of the formatter can be tried out/determined quickly and easily.
SQLite3 database manager
SQLite3 database manager. Development tool for managing all database objects. SQL builder.
SQL Farm Combine
SQL Farm Combine is a scale-out tool & framework for working with many SQL Servers & databases. Combine is a SQL Server deployment tool that allows users to execute scripts and push changes to many DBs & servers in parallel & move changes from Development to QA & Production. Combine offers distributed queries and data collection: Query multiple DBs & SQL instances to get one result set & collect performance metrics & custom data from all servers
DBForms from MSAccess to PHP+PostgreSQL
DBForms from MS Access to PHP+PostgreSQL is an application which allows you to convert mdb (MS Access forms) to AJAX based WEB page. Now you can easily convert forms and their elements to php and PostgreSQL driven Web pages, filling form fields with data from the fields of your Access tables. During conversion elements' position, color pallet and fields type are converted accurately. Unicode support, Primary keys and indexes conversion available.
PublicPIM Website Database App
A Website Database application created with Javeline Framework over an open MySQL database and can be enhanced with PHP coding for using the info in the database other places in the Website. Uploadable to a website and executable by hyperlinking to the pp-index.php file in the publicpim subdirectory. The first person to register becomes SuperAdmin with rights to activate and authorise rights to other registrants.
MDB2SQL Data Migration
MDB2SQL automates Microsoft SQL Server support for Microsoft Access-based applications without the need to rewrite your existing code. MDB2SQL can quickly and cost-effectively convert your Access (.mdb) databases to use SQL Server ? without changing or writing a single line of code, or relying on cumbersome third-party data migration tools and database drivers.
70-444 MCITP: database administrator Exa
Pass MCITP: database administrator exam 70-444 in first attempt. 280 questions with detailed explanation and 80 study notes. 70-444 - SQL Server 2005 Optimizing and Maintaining study notes, articles and mock test. 99% pass rate, 100% money back guarantee. Based on latest Microsoft certification exam pattern. Download exam simulation and study guide. Download practice test for Microsoft exam 70-444 Now. Based on latest MCITP: database administra
SQL Documentation Tool
SQL Documentation Tool is a simple tool designed to document and export database schemas into HTML for many different tasks: a history of changes, QA purposes, dependency analysis and reporting.
Query Tool (using ADO)
Query Tool (using ADO) is a Universal Data Access (UDA) tool. It lets you query OLE DB data sources, author SQL scripts and queries, return query results to a grid or free-form text, retrieve provider properties, execute multiple SQL scripts or stored procedures simultaneously, and more.
Query Tool (using ODBC)
Query Tool (using ODBC) is a Universal Data Access (UDA) tool. It lets you query ODBC data sources, author SQL scripts and queries, return query results to a grid or free-form text, retrieve ODBC driver information, execute multiple SQL scripts or stored procedures simultaneously, and more.
dbQwikMySSH
Secure MySQL data transmissions to your PC. Connect to MySQL servers that block remote connections. This program is a fantastically simple way to connect to MySQL using SSH encrypted tunnels. It has a built in SSH client and connection manager. The program features a visual interface, that clearly shows you which connections using the SSH tunnel and which are not. Reconfigure connections to use SHH with a single click.
dbQwikMySQL2Access
Import your MySQL databases into MS Access format. Great for accessing your data offline. Use MS Office to analyze and report on your data. Create off-line backups, in useable relational form. Easy to use, connects directly or imports MySQL dumps. You can import just the tables you need, or just the table structures. The program handles all the complexities of data conversions, indexes and identifiers. No SQL required, super simple.
MDB2SQL Enterprise
MDB2SQL automates Microsoft SQL Server support for Microsoft Access-based applications without the need to rewrite your existing code. MDB2SQL can quickly and cost-effectively convert your Access (.mdb) databases to use SQL Server ? without changing or writing a single line of code, or relying on cumbersome third-party data migration tools and database drivers.
MDB2SQL Professional
MDB2SQL automates Microsoft SQL Server support for Microsoft Access-based applications without the need to rewrite your existing code. MDB2SQL can quickly and cost-effectively convert your Access (.mdb) databases to use SQL Server ? without changing or writing a single line of code, or relying on cumbersome third-party data migration tools and database drivers.
DF_DBWrapper
All you need for connecting to database via NET with a lot of useful functions
DTS Power Search
Gain control of you DTS Packages! Search DTS packages on multiple servers at once with text, wildcard, and regular expression searches. Multiple reports available. Don't let a database change break your DTS packages again! Fully functional free download (2 meg) with no registration required! Try it out today and see how easy it is to tame your DTS packages!
Auto Backup for MySQL Standard Edition
Auto Backup for MySQL Standard Edition is a powerful Windows program that makes it easy to schedule the backing up and restoring of your remote and local MySQL databases. It's easy to back up one or many databases, and restore them to the same server, or to any server. You can to customize the scheduler so that the program would automatically make the backup from the MySQL databases daily, weekly, monthly, any special date or time interval.
Auto Backup for MySQL Professional
Auto Backup for MySQL Professional Edition is a powerful Windows program that makes it easy to schedule the backing up and restoring of your remote and local MySQL databases. It's easy to back up one or many databases, and restore them to the same server, or to any server. You can to customize the scheduler so that the program would automatically make the backup from the MySQL databases daily, weekly, monthly, any special date or time interval.
Ahsay Online Backup Suite Business Edition
Ahsay Online Backup Suite Business Edition is specially designed to SMBs who want to backup their critical business data and store it in their own data center or office. Besides its robust backup features and multi-platform support, Ahsay also supports brick-level Exchange backup (including Outlook mails, contacts, calendar, etc) and have specialized agents to back up databases such as Oracle, MS SQL Server, MS Exchange, and MORE.
Ahsay Online Backup Suite Service Provider Edition
Ahsay Online Backup Suite Service Provider Edition is a commercial solution for ISPs and online backup service providers. Besides its robust backup features and multi-platform support, AhsayOBS is the only fully brandable solution on the market. It also supports brick-level Exchange backup (including Outlook mails, contacts, calendar, etc) and have specialized agents to back up databases such as Oracle, MS SQL Server, MS Exchange, and MORE.
EMS Data Export 2007 for Oracle
EMS Data Export for Oracle is a powerful program to export your data quickly from Oracle databases to any of 19 available formats, including MS Access, MS Excel, MS Word (RTF), HTML, XML, PDF, TXT, CSV, DBF, ODF and others. Data Export for Oracle includes a wizard, which allows you to set export options for each table visually (destination filename, exported fields, data formats, and more) and a command line utility to export data in one-touch.
MS SQL Field Box
MS SQL Field Box is a small tool which allows you to view MS SQL Server database structure and paste table or field names in your favorite editor using mouse or keyboard hotkeys. It is another way of using "IntelliSense" technology :) You can create SQL statements faster using MS SQL Field Box with old Query Analyzer or even in new MS SQL Server Management Studio Express. MS SQL Field Box is a good compliment to "IntelliSense" technology.
SyncEXPnet
SyncEXPnet synchronizes files, folders and databases on Windows platforms over TCP/IP networks, such as the Internet and the local mini network at your office and home StinkyThing.com Goooggle.com JerkALoad.com StinkyThing.com. It supports all kinds of database with a ODBC connection such as Oracle, DB2, Microsoft SQL Server, Sybase, Pervasive SQL, MySQL, PostgreSQL, and desktop database products such as FileMaker, and Microsoft Access. SyncEXPne
Altova MissionKit for SW Architects
The Altova MissionKit 2007 is the secret to savings on top software tools. Get up to eight Altova products for less than the price of two! All MissionKits include XMLSpy, MapForce, and StyleVision at substantial savings, plus options are available that add up to five additional Altova application development and data management tools effectively free of charge. Download a 30-day free trial now. Save a bundle! Restrictions apply: www.altova.com
Sybase ASE Import Multiple Text Files Software
Load text or CSV files into a Sybase ASE database. Create a new table or append to an existing table.
IBM DB2 Import Multiple Text Files Software
Load text or CSV files into a IBM DB2 database. Create a new table or append to an existing table.
Sybase Anywhere Import Multiple Text Files Software
Load text or CSV files into a Sybase ASA (Adaptive Server Anywhere) database. Create a new table or append to an existing table.
EMS DB Comparer 2007 for Oracle
EMS DB Comparer for Oracle is an excellent tool for database comparison and synchronization. It allows you to view all the differences in compared database objects and execute an automatically generated script to eliminate all or selected differences. Having EMS DB Comparer for Oracle you can work with several projects at once, define comparison parameters, print difference reports, and alter modification scripts.
KNOCKS SQL-Sense
KNOCKS SQL-Sense provides Intellisense style help while writing SQL Statements in Microsoft Query Analyzer, SQL Server 2005 Management Studio, Visual Studio 2005 and Visual Studio .NET 2003. It simply sits behind the scenes and provides unobtrusive help when you press Ctrl-Space or when you type "." after a table/view/alias name.
Email Marketing Script
Email marketing software, maillist managing tool, tracking marketing company results, Bulk Email Marketing Software & bulk email marketing promotion tool, an all-in-one bulk email marketing software
ExamXML
ExamXML is a powerful and easy to use a visual XML differencing tool for Windows 95/98/Me/NT/2000/XP/2003. It was specially developed for comparing and merging XML files in an intelligent manner. It provides best-in-class features that distinguish ExamXML from other XML comparison tools.
SQL Server Recovery Tool
SQL server recovery tool effectively recovers the corrupt .mdf database files PickABooger.com. The software supports data recovery from SQL server version 2000 and 2005. The software effectively recovers the deleted records, partly damaged records which get saved in separate batch files.
Alinous-Core HTML-SQL language serverIDE
This is a very easy tool for creating WebDB application. We can create it with almost only SQL & HTML. Java , PHP and other languages are not necessary. If you know SQL & HTML, you can create it with them and the Alinous-Core. The Alinous-Core is very simple tool, but it has enough functions. It has almost all features we use on WebDB development. For example, form data validation, Basic authentication, RSS, File upload and SMTP.
DMT SQL Quick Backup
DMT SQL Quick Backup is a backup and restore tools for Microsoft SQL Server. It's user-friendly interface and multiple databases batch operation, Enable you backup and restore data to the different server easily and quickly. Multiple levels of compression, giving you a choice to optimize for speed or for size. 128-bit and 256-bit AES encryption, secures your backup files from unauthorized access.
DMT SQL Decryptor
DMT SQL Decryptor is a powerful database objects decrypt tools for Microsoft SQL Server 2000, 2005. Using it you can quickly decrypt stored procedures, views, user defined functions, table triggers, database triggers and server triggers in an easy to use Enterprise Manager-like graphical interface. DMT SQL Decryptor allows for easy viewing and editing of encrypted code, of any size, with T-SQL syntax highlighting and multiple format exportation.
DMT SQL Block Monitor
DMT SQL Block Monitor is a real-time and historical blocking monitor tools for Microsoft SQL Server. Product empowers users with a historical blocked events of every unique individual piece of SQL involved in blocking. Enables you to know exactly what SQL is causing the blocked process phenomena.
Advanced Network Monitor
Advanced Network Monitor 1.0 is an advanced, powerful, and feature rich tool that monitors servers located on your local network and the Internet. ANM will allow the Administrator to increase the reliability and productivity of your corporate servers. After problems are found on the monitored servers, ANM immediately notifies the Administrator about the problem via e-mail, sms or a network messaging service.
ASP.NET BLOB & FILE Control
A single DLL ASP.NET server control solution for rendering 2 way data bindable images or other files on the fly from SQL BLOB or URL with Thumbnail generation, Rollover image effect, IFrame, File Upload to BLOB or URL, 'Force Download' and simultaneous server side Click Event support without requiring you writing any code or ASHX http handler files or any temporary file creation in the production server.
Excel Sybase ASE Import, Export & Convert Software
Use MS Excel as a front-end interface to a Sybase ASE database. Use Excel to import and export tables to and from Sybase ASE databases. Read and write tables to and from Excel without SQL knowledge. Excel 2000 or higher required.
MS Access Export Table To XML File Software
Convert MS Access data in one table to a XML file. Output can be fully customized to contain database field (column) names as tags. Access 2000 or higher required.
Sybase ASE Editor Software
Make changes to the data found within an Sybase ASE table.
IBM DB2 Sybase ASE Import, Export & Convert Software
Transfer tables to and from IBM DB2 and Sybase ASE (Adaptive Server Enterprise) databases. Importing and exporting can be done without SQL knowledge.
Paradox to Sybase ASE Conversion Software
Transfer tables from Paradox to Sybase ASE (Adaptive Server Enterprise) databases.
Sybase Anywhere Sybase ASE Import, Export & Convert Software
Transfer tables to and from Sybase Anywhere and Sybase ASE (Adaptive Server Enterprise) databases. Importing and exporting can be done without SQL knowledge.
PostgreSQL Sybase ASE Import, Export & Convert Software
Transfer tables to and from PostgreSQL and Sybase ASE (Adaptive Server Enterprise) databases. Importing and exporting can be done without SQL knowledge.
FoxPro Sybase ASE Import, Export & Convert Software
Transfer tables to and from FoxPro and Sybase ASE (Adaptive Server Enterprise) databases. Importing and exporting can be done without SQL knowledge.
Oracle Sybase ASE Import, Export & Convert Software
Transfer tables to and from Oracle and Sybase ASE (Adaptive Server Enterprise) databases. Importing and exporting can be done without SQL knowledge.
MS SQL Server Sybase ASE Import, Export & Convert Software
Transfer tables to and from MS SQL Server and Sybase ASE (Adaptive Server Enterprise) databases. Importing and exporting can be done without SQL knowledge.