Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

Database News

Posted Feb 18, 2004

SQL tool for database scripting updated

By DatabaseJournal.com Staff

[From Apex SQL Tools]

Apex SQL Script, a SQL tool for database scripting, has been updated to support all SQL datatypes (image, text, etc) except SQL variant and the SQL script generation engine is now exponentially faster. Apex SQL Script is used to script SQL data into insert scripts that can be archived, versioned, emailed or run against another database.

New Features:

  • Tremendous performance improvements especially on large tables
  • Support for all sql datatypes (including Text, Image, sql_variant etc)
  • Ability to append where clause to Table/Views via interface
  • Table / View aliases so you can script one table/view to a different table/view
  • Column level scripting - this feature allows you to pick and choose what columns you want to include in the script
  • Table/View level row limits. Now you have the option to limit the number of rows to script on an individual Table / View level
  • Allows you to suppress All Constraints and/or Triggers prior to running scripts

The article continues at http://www.apexsql.com/index_ai.htm

Database News Archives

Latest Forum Threads
Database News Forum
Topic By Replies Updated
Efficient SQL Server Indexing by Design lcole 0 April 30th, 12:38 PM
Mine Oracle Database, SQL Server and Other Databases with Monarch Data Pump Pro V10.5 lcole 0 April 30th, 12:37 PM
Oracle Database and Oracle Fusion Middleware for Private Social Network Application lcole 0 April 30th, 12:31 PM
Oracle Database Maintains a Stronghold in the DBMS Market lcole 0 April 30th, 12:30 PM