Moving from Development to Production, ASP.NET App

6 posts, 0 answers
  1. Jeff
    Jeff avatar
    51 posts
    Member since:
    Aug 2007

    Posted 25 Feb 2009 Link to this post

    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
  2. Jeff
    Jeff avatar
    51 posts
    Member since:
    Aug 2007

    Posted 26 Feb 2009 Link to this post

    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.
  3. DevCraft banner
  4. Dimitar Kapitanov
    Admin
    Dimitar Kapitanov avatar
    632 posts

    Posted 28 Feb 2009 Link to this post

    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.
  5. gmendez
    gmendez avatar
    82 posts
    Member since:
    Jun 2012

    Posted 06 May 2009 Link to this post

    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
  6. Jan Blessenohl
    Admin
    Jan Blessenohl avatar
    707 posts

    Posted 07 May 2009 Link to this post

    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.
  7. gmendez
    gmendez avatar
    82 posts
    Member since:
    Jun 2012

    Posted 07 May 2009 Link to this post

    Hello Jan,

    I found the example. Thanks a lot.
    Regards,

    Gonzalo
Back to Top
DevCraft banner