Generate Sql Schema

SQL::Schema is a Perl module to convert a data dictionary into SQL statements. SYNOPSIS use DBI; my $dbh = DBI->connect(...); use SQL::Schema; my $schema = SQL::Schema->new($dbh); my $sql = $schema->string; print $sql; print "$schema"; WARNING This is alpha software. It...

SQL::Generator is a Perl module to generate SQL-statements with oo-perl. SYNOPSIS use SQL::Generator; With this module you can easily (and very flexible) generate/construct sql-statements. As a rookie, you are used to write a lot of sprintf`s every time i needed a statement (i.e.for DBI)....

SQLCE Scripter is a GUI application which takes SQL CE database filename and generates database schema and data scripts. With the help of SQLCE Scripter you'll be able to easily create SQL schema and data scripts from SQL Server Compact 3.5 or 4.0 database file.


Platforms: Windows

SQL VB ASP Code Generator is a powerful multi-purpose tool that lets you effortlessly generate SQL, VB and ASP Code. You can even generate an entire VB application or ASP web application, all derived from the tables in your database with just one click. No more recreating the same old SELECT,...


Platforms: Windows

This script can generate SQL queries from objects or arrays. It can traverse the list of variables of the object or a given associative array and generate SQL INSERT or UPDATE queries to create or update records of a given database table.The names of the table fields are taken from the object...


Platforms: PHP

This PHP script can be used to connect to a given MySQL database server or to generate SQL statements which can be used to recreate the database tables and its contents.dbclass_dre can backup all tables or a given subset, And the backup data can be compressed into a zile files by a separate...


Platforms: PHP

sql_Generator class is meant to make it easier to generate SQL queries for inserting or updating records in a database table.Just specify the required fields, and then call the class functions to retrieve the SQL statement to perform an insert or update query.


Platforms: PHP

dbStringIt can be used to generate SQL statements to update database table records from submitted form field values.dbStringIt takes an array of posted form request values and combines the values to generate a string that can be used in an SQL UPDATE statement to update the fields of records with...


Platforms: PHP

Yet another tool to generate SQL statements from Dia XML files: CREATE TABLE, CREATE VIEW, CREATE TRIGGER, INSERT INTO, GRAND TABLE, and REVOKE. Defined automatically INDEXes, PRIMARY and FOREIGN KEYs. Generates automatically Tables for N:N connectivity.


Platforms: Windows, Mac, Linux

It can also optionally generate SQL queries to input the data into a database.


Platforms: Windows, Mac, *nix, PHP, BSD Solaris

Schema-compare is a script that will compares two database schema and show the differences side-by-side. Schema-compare can also generate SQL statements that will alter the old database to match the schema of the new database. The comparisons are correct, but the SQL statements at the bottom...


Platforms: *nix

Schema-compare is a PHP script that will compare two database schema's and show the differences side-by-side. It will also generate sql statements that will alter the old database to match the schema of the new database.


Platforms: Windows, Mac, *nix, PHP, BSD Solaris

SQL::Abstract::Limit is a portable LIMIT emulation. SYNOPSIS use SQL::Abstract::Limit; my $sql = SQL::Abstract::Limit->new( limit_dialect => LimitOffset );; # or autodetect from a DBI $dbh: my $sql = SQL::Abstract::Limit->new( limit_dialect => $dbh ); # or from a Class::DBI class: my...


Platforms: *nix

Ispirer's business is grounded on a cutting-edge migration tool SQLWays, which has the potential and powerful outcomes. It can take full control of the entire migration cycle providing high automation of all migration phases. SQLWays converts stored procedures, functions, triggers, database...


Platforms: Windows, *nix, DOS

Schema Sync will generate the SQL necessary to migrate the schema of a source database to a target database (patch script), as well as a the SQL necessary to undo the changes after you apply them (revert script).


Platforms: *nix

All DB Backup can be used to take a backup of a database to a file with SQL statements that can be used to restore the database. It can generate SQL statements that can be used to restore just the database table data or also the database table schema.All DB Backup uses the PEAR::DB abstraction...


Platforms: PHP

Log2SQL is a program that imports (converts) web-server logs into an SQL-database. Both W3C and NCSA web log formats are supported. After importing it becomes extremely easy to perform complex queries and searches with your logs, and finally, analyse your web-site statistics more efficiently....


Platforms: Windows

Yet Another dia2sql is a tool that generates SQL statements from Dia XML files. yadia2sql is intended to process diagrams that are compatible with dia2sql.php to some point, and provide features that would allow generation of SQL code for different database systems from single Dia source....


Platforms: *nix

Jifty::DBI::SchemaGenerator is a Perl module to generate table schemas from Jifty::DBI records. This module turns a Jifty::Record object into an SQL schema for your chosen database. At the moment, your choices are MySQL, SQLite, or PostgreSQL. Oracle might also work right, though its untested....


Platforms: *nix

Yukatan data model project is the schema definition of the Yukatan webmail database. The PostgreSQL database structures defined in this file can be used as a backend store of an email message handling application. The database should be created with the "UNICODE" encoding to properly support...


Platforms: *nix