v1.1.3

Rating: No reviews yet
Downloads: 40
Change Set: 5312
Released: Apr 9, 2011
Updated: Apr 9, 2011 by Martinjw
Dev status: Stable Help Icon

Recommended Download

Application DatabaseSchemaReader.zip
application, 837K, uploaded Apr 9, 2011 - 40 downloads

Release Notes

Zip file contains binary dll with a simple UI to read database schemas.

DatabaseSchemaViewer

DatabaseSchemaViewer.exe is a simple Windows Form UI.

* Select database provider from dropdown (eg System.Data.SqlClient)
* Enter connection string
* Enter database schema (owner for Oracle).
* Click button.

For code generation,
  • After loading schema (see above) click gears icon. A new form opens.
  • Enter file path to generate to
  • Select C# classes (with NHibernate mapping), Table DDL or SQL Stored Procedures
  • For C# generation, enter namespace
  • For C# generation, if you want typed stored procedure classes, check the box
  • Enter dialect (SqlServer, Oracle or MySQL) for Table DDL or SQL procedures. You can do (simple) translation from one database to another.
  • Click button.

CopyToSQLite

New
CopyToSQLite.exe is in a subfolder. You do not have to have SQLite or the ADO provider installed.
It will read a schema from any database (SqlServer, Oracle, MySQL, SQLite) and create a new SQLite database file with a copy of the tables and data.
If you have SqlServer CE 4.0 installed, it will also offer to create a SqlServer CE 4.0 database. This has limitations and is less robust than the SQLite copy.

Reviews for this release

No reviews yet for this release.