The Database Facade library offers a way to access miltiple vendor databases with code that does not need to change from vendor to vendor.
The library offers a set of java classes and methods that
... [More] allow the user to define create, select, update, insert and delete statements that will function on different databases.
The facade when initialized decided weather it needs an MySQL, MSSQL, Oracle, Informix or generic AnsiSQL-92 translator and performs the staments in native form.
For example IsNull() is a function in MSSQL that has a counter part in Oracle. The nullDefaultReplacement() method will produce the proper SQL for both databases. [Less]
The project summary basically explains it. Beyond that put your tables from oracle sql developer (samples provided) into the input folder. run the python file. The SQL creation code for these will be put in the output folder.
Enjoy!
This utility would help convert Ms word 2007 Tables to Sql tables.
Add this macro to any word docx document and Run the macro.
We get a text file containing all the tables which follow the naming
... [More] convention converted into sql DDL statements.
You just need to follow some naming conventions.
Described in detail in the releases Tab. [Less]
Database MySQLDumpA MySQL to PHP Dump Class and Control script..
Database MySQLDump is a script written in PHP for dumping entire database's into a MySQL import friendly format. This script is based
... [More] off my own ideas as well as looking at others scripts that do similar tasks. The generalized aim of this project is to create an all in one light-weight script that does all of the tasks other scripts do plus more. To read more about the aim, read below.
Project Aim:This project is aimed at developing a simple, XHTML 1.0 Strict Markup valid PHP MySQLDump Class and control page. Eventual goals are to support dumping data into a .sql and .sql.gz file, having a control script that requires user input to select the Server, Database Name, User Name, Password, and if to include DROP statements in the drop.
It's aimed that the script remains XHTML 1.0 Strict friendly according to W3C (World Wide Web Consortium) Markup standards. It's also aimed that the script itself remains completely light weight as to prevent problems with the dump itself, as many databases can be quite large.
Other possible additions once time goes on is on server backups to .sql or .sql.gz files, as well as the addition to creating customized cronjob backup scripts for your website automatically (user would have to direct their web server to the cronjob script).
Additional goal is to maintain a relatively easy to use control file that anyone can edit. Keeping the inner workings of the script stored in the class file is the main method of ensuring this. Anyone can make their own control file, as long as they print the Copyright line for the Class Script (included in the sample Control file). [Less]
SQL Comparator is a C# Windows application designed to facilitate rapid minimal change database validation, which is capable of connecting to any ODBC compliant data source such as Microsoft SQL
... [More] Server or Oracle.
SQL Comparator runs two user defined queries and compares the results in a graphical mode designed to facilitate the identification of minimal differences in complex tables. The tool will calculate and highlight any row, column, and cell-based differences between the two datasets. The tabular data is displayed in two datagrids which are positionally synchronized and where differing cells are visually highlighted. [Less]
AboutPackend is free, opensource and simple. With Packend you can create simple interfaces to input and manage data. Checkout the SVN for new files. ExampleA database of books, with the ability to add, edit or delete.
RequirementsPHP MySQL