Try Now
More in this section

Forums / Deployment / Databases & Deployment

Databases & Deployment

4 posts, 0 answered
  1. Timothy Masson
    Timothy Masson avatar
    7 posts
    17 Oct 2004
    21 Jun 2007
    Link to this post
    I've been develping locally with SQL 2005, but my production server is SQL 2000. I've tried to compare the two DB's, but SQL 2005 uses the Max keyword while 2000 does not. I imagine that i can change this and just generate a sql script to create the sql 2000 db. However, I'm curious if there are any other differences in the way that Sitefinity would treat a 2000 vs 2005 db?

    Thanks in advance,
  2. Vassil Daskalov
    Vassil Daskalov avatar
    261 posts
    18 May 2013
    22 Jun 2007
    Link to this post
    Hi Timothy Masson,

    Unfortunately, the transition from SQL 2005 to SQL 2000 is a problematic issue. Perhaps you could get information from Microsoft support. I can only suggest you try to export your database in case you have a connection to the deployment database server but I cannot guarantee you that this will do the job.

    Hope you will find your solution.

    Sincerely yours,
    Vassil Daskalov
    the Telerik team

    Instantly find answers to your questions at the new Telerik Support Center
  3. John Bailey
    John Bailey avatar
    2 posts
    10 Nov 2002
    13 Aug 2007
    Link to this post
    Okay, since migrating between SQL 2005 and SQL 2000 is problematic, how do you install on a SQL 2000 machine?  The installation instructions specify that SQL 2000 is supported, but then give no instructions as to how to install against SQL 2000.

    If I create a database in 2000 compatibility mode on my development SQL 2005 server, I would imagine I can move between it and my SQL 2000 production server without issue (I do with other products).
  4. Slavo
    Slavo avatar
    295 posts
    24 Sep 2012
    14 Aug 2007
    Link to this post
    Hi John Bailey,

    Sitefinity fully supports SQL Server 2000. There is no problem to set up a project to work with it, if you do it in the beginning. As you know, when you create a project, Sitefinity asks you for the type of DB server you will use. What is problematic is to migrate the DB from SQL 2005 to SQL 2000, once already created. SQL Server 2005 itself does not support downgrading databases to SQL 2000. This is a really problematic issue and I have had problems with it in the past, even when using SQL 2000 compatibility mode. The only solution I have found is to generate a script in SQL 2005, modify it manually and execute it against the SQL 2000 DB. This has to be done both for creating the DB schema and inserting the already existing data. It is basically a trial and error game, unless you know what parts of the script would not work for 2000.
    If you have migrated databases from 2005 compatibility mode to 2000 in the past with no problems, then you might succeed with this. Just try it on a new project, created for 2005. There is a way to do it with DTS packages, which I haven't tried. Just search for it in Google.
    My advice is to use the same DB server on your development machine and production server. You will avoid much hassle and save a lot of time. I also do not see a single reason not to do it. There is even a free version of SQL 2000 called MSDE, which is analogous to SQL 2005 Express.

    Kind regards,
    the Telerik team

    Instantly find answers to your questions at the new Telerik Support Center
Register for webinar
4 posts, 0 answered