+1-888-365-2779
Try Now
More in this section

Forums / Deployment / Remote -vs- Local SQL Server

Remote -vs- Local SQL Server

4 posts, 0 answered
  1. Mike Henderson
    Mike Henderson avatar
    3 posts
    Registered:
    19 May 2010
    31 May 2010
    Link to this post
    We just purchased a license and I am in the process of installing Sitefinity at our school.  My question is this, should we use SQL Server on a remote system or have it on the webserver itself?  Also, for a "TEST" or "DEVELOPMENT" installation, is it necessary to have it on a seperate physical system?  Would a seperate website on the same box as the "PRODUCTION" website suffice?

    Thanks...

    mh
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    09 Dec 2016
    31 May 2010
    Link to this post
    Hi Mike Henderson,

    There is no functional difference between the remote and local SQL server. Generally, the requests to the local SQL server will be processed faster. The local server uses the resources of your local machine, since the remote SQL server will use separate resources - RAM, CPU etc. Using remote SQL server is useful in cases of host failures. If somehow your current host goes down and the SQL server is on the same machine your website/intanet will not be accessible.
    The tes/dev project could be again on the same or another server ( for another server you should use Remote Desktop Connection).

    Best wishes,
    Ivan Dimitrov
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
  3. Mike Henderson
    Mike Henderson avatar
    3 posts
    Registered:
    19 May 2010
    31 May 2010
    Link to this post
    Thanks for the quick response.  Just one more and I will leave you alone.

    Does each project require it's own database or can there be just one database the serves the entire site (multiple projects)?

    Thanks again..

    mh
  4. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    09 Dec 2016
    31 May 2010
    Link to this post
    Hi Mike Henderson,

    It is possible to use shared database - Run Multiple website from a sigle database, but you should better use separate database. There is no exporter tool that will allow you to extract an project from a shared database.

    Greetings,
    Ivan Dimitrov
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Register for webinar
4 posts, 0 answered