Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005

    Unanswered: can a SQL2005 DB be hosted on a SQL2000 server ?

    I'd like to host a small website created using VS2005 EE with a company that offers just SQL2000 DB support.
    My question, can i use the DB created by VS site manager as a DB to the site, if not, is there any alternatives.

  2. #2
    Join Date
    May 2004
    in general, this won't work. what you are asking for is forward compatibility, which is impossible to deliver in practice. it's like expecting apps written for Vista to work on windows 95. If you are developing for 2000, you should use the 2000 tools.

    on the other hand, as long as your db doesn't use any 2005 features not present in 2000 (such as CLR procs, xml columns, etc) then your DDL scripts should execute ok.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts