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

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
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

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




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


















Thanks for your registration, follow us on our social networks to keep up-to-date