OpenAccessSchemaTool

Hi.

Is it possible from code, by including a reference to "VSchema.exe", to Create a new instance of "OpenAccessSchemaTool" found in "VSchema.exe", set the properties and call "Execute()" instead of running it from a DOS Command window?

Regards

Paul

Hi Pål,

It is not allowed to ship the vschema tool. It requieres a license. What exactly do you want to do?

Regards,
Jan Blessenohl
the Telerik team

Hello Pål,

Sorry, wrong answer, this was about venhance.

You can do that, but why?

Sincerely yours,
Jan Blessenohl
the Telerik team

Hi Jan.

What I'm trying to do is embed some options (recreate/update/verify database) in my deployed applications to handle database schema synchronisation.

There are many reasons why this is valuable, but the latest that I found was doing Test driven development (Unit test).

Given a Test assembly, I can pass a "recreate" parameter in the config file (which will usually be set to "verify"). This will completely erase the database and rebuild it from scratch. This will give a test environment which will always have the same starting point and as the tests are executed, the database content always ends up the same.

The best soulution of course, would be if these tools ("OpenAccessSchemaTool") and its relations were copied into OpenAccess.dll, or a separate library, say, "OpenAccess.Tools.dll" or something... The reason for this is of course that some companies/clients may have a problem with us installing third-party executables on their machines. You know how demanding customers can be... ;-)

Is this something you would be able to do?

Regards

Pål

Hi Pål,
You can do it, but I think just start the new process calling vschema.exe via command line is less code.

Best wishes,
Jan Blessenohl
the Telerik team