Suggesting RH as your database builder

[GoogleCodeExporter]

Very simple api to create databases (https://gist.github.com/977990) that uses 
plain old sql scripts.

Minimum api:
new Migrate().Set(p =>
{
    p.DatabaseName = databaseName;
    p.SqlFilesDirectory = scriptsLocation;
    p.Silent = true;
})
.Run();

More standard:
new Migrate().Set(p =>
{
    p.ConnectionString = connectionString;
    p.SqlFilesDirectory = scriptsLocation;
    p.EnvironmentName = environmentName;
    p.Drop = dropDatabase;
    p.RecoveryModeSimple = useSimpleRecoveryMode;
    p.Restore = restore;
    p.RestoreFromPath = restorePath;
    p.RepositoryPath = repositoryPath;
    p.VersionFile = versionFile;
    p.VersionXPath = versionXPath;
    p.Silent = true;
})
.Run();

I am porting the documentation to https://github.com/chucknorris/roundhouse/wiki

You can also just call the tool which is a simple executable.

Original issue reported on code.google.com by trueblu...@gmail.com on 16 Jun 2011 at 1:40

[GoogleCodeExporter]

Original comment by DaveWood...@gmail.com on 16 Jun 2011 at 6:28

• Added labels: Type-Enhancement
• Removed labels: Type-Defect

[GoogleCodeExporter]

I could spike this out for you if you would like and submit a patch.

Original comment by trueblu...@gmail.com on 16 Jun 2011 at 8:11

[GoogleCodeExporter]

This will give you oracle, mssql 2000-2008, and in a couple of days mySQL.
I added it with your current fluent interface and it works, but some of the 
things you have in your current may change based on using RH. I'll make some 
notes in the patch file.

Original comment by trueblu...@gmail.com on 16 Jun 2011 at 8:46

[GoogleCodeExporter]

Here is a rough draft idea...it needs a little logging hooked up to it though.

Original comment by trueblu...@gmail.com on 16 Jun 2011 at 9:06

Attachments:

• rh.fb.patch
• tools.zip

[GoogleCodeExporter]

Let's try that patch file again, been awhile since I've done this... :D

Original comment by trueblu...@gmail.com on 16 Jun 2011 at 9:09

Attachments:

• rh.fb.patch