Schema Validation

5 posts, 0 answers
  1. Pål
    Pål avatar
    53 posts
    Member since:
    Sep 2012

    Posted 11 Dec 2008 Link to this post

    Hi.

    I'm trying to use VSchema.exe to validate a database schema against an application, but I don't want it to make any changes. Only report success or fail, possibly with a message.

    The documentation says:

    "Use the -create switch to create and/or validate the database tables for your model"

    So, does this mean that if I use the "-validate" switch:

    1: No changes will be made and schema will be verified.
    2: Changes will be made and schema will be verified?

    If 2, is there another way to just verify the schema?

    Ragards.

    Pål
  2. Jan Blessenohl
    Admin
    Jan Blessenohl avatar
    707 posts

    Posted 12 Dec 2008 Link to this post

    Hi Pål,
    There is an option -direct- which means that the changes are not executed against the database but only written to the DDL script file. If you check for the file existence of the file you have what you want.

    All the best,
    Jan Blessenohl
    the Telerik team

    Check out Telerik Trainer, the state of the art learning tool for Telerik products.
  3. DevCraft banner
  4. Pål
    Pål avatar
    53 posts
    Member since:
    Sep 2012

    Posted 12 Dec 2008 Link to this post

    Of course. Silly me.

    Thanks. :-)

    Pål
  5. Christian
    Christian avatar
    81 posts
    Member since:
    Aug 2008

    Posted 10 Jun 2009 Link to this post

    Hi,
    as part of the development classes have been created and removed again. In the database are the 'old' tables yet exist. Is there a tool with which I can determine which tables do not have classes in the mapping? A list would be great. My
    Thanks in advance. I want to selectively delete unnecessary tables.
    Christian
  6. Jan Blessenohl
    Admin
    Jan Blessenohl avatar
    707 posts

    Posted 10 Jun 2009 Link to this post

    Hi Christian,
    We do not detect the additional tables. In the update process we read only the old state of the used columns in your application. You can generate a fresh schema and use the database schema diff tool to find the not longer necessary tables.

    All the best,
    Jan Blessenohl
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Check out the tips for optimizing your support resource searches.
Back to Top
DevCraft banner