Mini SQL Query

I have finally had a chance to put together a simple “Quick Start” document for Mini SQL Query. It’s the main reason I have never made a formal “version 1” release!

Here is a link to the document: http://pksoftware.net/MiniSqlQuery/Help/MiniSqlQueryQuickStart.docx

I also “upgraded” the projects to version 3.5 of the framework as the version 2 requirement is all but gone. That was more around my usage on Windows Server 2003 etc.

PK :-D

I have finally had a chance to put together a simple “Quick Start” document for Mini SQL Query. It’s the main reason I have never made a formal “version 1” release!

Here is a link to the document: http://pksoftware.net/MiniSqlQuery/Help/MiniSqlQueryQuickStart.docx

I also “upgraded” the projects to version 3.5 of the framework as the version 2 requirement is all but gone. That was more around my usage on Windows Server 2003 etc.

PK :-D

All,

I uploaded RC1 today: http://minisqlquery.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=33994

Lots of goodies including the new generic schema engine and text templating including access to the data.

One of the
regular questions I get is if there is a plug-in that will convert “database A”
to “database B”… answer… no – BUT – you can actually write a script connected
to database A that writes out the schema for database b. Then you would run the
generated SQL against database b. You could for example even create a db layout
using Excel (one table per sheet etc), connect to it with Mini SQL Query and
write a script that is a “create script” for the destination database. You can
also get the data out with the template tool.

What’s
Missing?

• Schema wise
  the main thing missing is procedures/functions. Not all languages support them
  but it would be good to have for v1.
• Another
  schema addition is foreign key information for other databases. This is not
  provided properly by the ADO.NET schema functions and so I manually provide it
  for the respective database driver.

PK  :-)