This question is locked. New answers and comments are not allowed.
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
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
0
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.
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
Rank 1
answered on 12 Dec 2008, 02:52 PM
Of course. Silly me.
Thanks. :-)
Pål
Thanks. :-)
Pål
0
Christian
Top achievements
Rank 1
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
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
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.
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.