This is a migrated thread and some comments may be shown as answers.
Schema Validation
4 Answers 42 Views
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Pål
Top achievements
Rank 1
Pål asked on 11 Dec 2008, 11:26 AM
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

4 Answers, 1 is accepted

Sort by
0
Jan Blessenohl
Telerik team
answered on 12 Dec 2008, 02:41 PM
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.
0
Pål
Top achievements
Rank 1
answered on 12 Dec 2008, 02:52 PM
Of course. Silly me.

Thanks. :-)

Pål
0
Christian
Top achievements
Rank 1
answered on 10 Jun 2009, 07:11 AM
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
0
Jan Blessenohl
Telerik team
answered on 10 Jun 2009, 07:41 AM
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.
Tags
Design Time (Visual Designer & Tools)
Asked by
Pål
Top achievements
Rank 1
Answers by
Jan Blessenohl
Telerik team
Pål
Top achievements
Rank 1
Christian
Top achievements
Rank 1
Share this question
or