by Paul Kohler
5. October 2009 21:10
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 :-)
Subscribe