More in this section

Forums / Developing with Sitefinity / Sitefinity Database Stored Procedures

Sitefinity Database Stored Procedures

2 posts, 0 answered
  1. David
    David avatar
    50 posts
    Registered:
    14 Jan 2009
    18 Mar 2009
    Link to this post
    Hello,

    I just have a few questions about the stored procedures and how they work. Hopefully someone can shed some light on this subject for me.

    Firstly, at any point, do the stored procedures change, get added or removed at any point? Primarily I ask for backup purposes. If I back up the database, and later the stored procedures become corrupted, will restoring the stored procedures to an earlier time interfere with anything?

    Secondly, if I want to synchronize data between two existing Sitefinity projects, will there be any differences in the stored procedures?

    Thirdly, are there any differences in the stored procedures for Sitefinity 3.5 and 3.6?

    Thanks
  2. Georgi
    Georgi avatar
    3583 posts
    Registered:
    28 Oct 2016
    18 Mar 2009
    Link to this post
    Hello David,

    Here are the answers:

    Firstly, at any point, do the stored procedures change, get added or removed at any point?

    If you are not performing an upgrade, the stored procedures do not change. They are placed when the database is created, and remain the same after that. I am not sure how you will corrupt the stored procedures, but if you restore them with such from the same version, there will be no problems at all.

    Secondly, if I want to synchronize data between two existing Sitefinity projects, will there be any differences in the stored procedures?
    If two or more projects are connected to the same database, then these projects should use the same version of the CMS. Otherwise, on each operation with the database, it will be upgraded/downgraded in order to satisfy the schema version, required by the application. This might cause a lot of issues, when several users in several projects are working at the same time.

    Thirdly, are there any differences in the stored procedures for Sitefinity 3.5 and 3.6?

    There are differences. We have added a few more properties to pages and other stuff, that requires the procedures to be changed too. I am not able to provide you the exact changes now, because we use ORM which automatically handles the classes and stored procedures.

    Let me know if I could be of further help.

    Sincerely yours,
    Georgi
    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.
2 posts, 0 answered