Moving from Development to Production, ASP.NET App

[Jeff]

I haven't seen this topic covered anywhere so I'm asking here: What is the best way to move an OpenAccess-enabled web application to a production environment. Once there, how are new schema changes pushed out production environment?

Thanks,
Jeff

[Jeff]

OK, after reading this post, I'm getting closer to my answer: OpenAccess creates SQL files in the project's Debug directory for any required schema changes.

I suppose I could create a batch file to execute the SQL files then quickly update the corresponding OpenAccess-enabled assembly.

However, I'm hoping there's a more elegant and less error-prone method built in to OA.

[Dimitar Kapitanov]

Hi Jeff,
I believe there is no fully automated way for OpenAccess to accomplish the database schema update. You can indeed create a batch file for all the updates. You can take a look at the VShema utility which you may find useful.

Best wishes,
Dimitar Kapitanov
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.

[gmendez]

Hello, I have another question regarding this.
While developing, I'm enabling my project to work with a given SQL Server Express database. I must specify the server and the database name and this information is stored at the app.config file.
At the production environment the settings will be different. To start with, the server name will be different and it will be SQL server 2005 full.
Since the app.config file is compiled as an embedded resource I must have access to the final database server otherwhise my application won't compile. And I believe that for the same reason, I just can't compile against my local sql server and then modify and deply the app.config.
I'm I missing something? Which would be the right way for deploying apps when the development environment is different of the production environment?
Thanks in advance,

Gonzalo

[Jan Blessenohl]

Hello gmendez,
The Database is connected by an initial Telerik.OpenAccess.Database.Get() call. This call can take a xml document that replaces the app.config content. An example can be found at the function description in the reference guide.

Regards,
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.

[gmendez]

Hello Jan,

I found the example. Thanks a lot.
Regards,

Gonzalo