Skip to main content
A
Anonymous
April 16, 2006
Question

export a database from ms sql 2005 to ms sql 2000

  • April 16, 2006
  • 1 reply
  • 224 views
Hi:
I have Microsoft SQL 2005 Standard in my PC, I use CF 7.0/MS SQL 2005 to make my application. I bought a 2 year hosting from Webserve.ca (NT PRO package). Webserve.ca has MS SQL 2000. My problem is: If I design it in ms sql 2005 then export it as a single file then import it in ms sql 2000 (in my webserve hosting) will I have any problem? I mean I am worried about incompatibilities and something like that. I have a short time for makeing that so I have no time for making it again and if you tell me it will have some problems I will have to buy/use a MS SQL 2000. So please help me and tell me what should I do.
Thanks
Benign
    This topic has been closed for replies.

    1 reply

    P
    philh
    Inspiring
    April 17, 2006
    The only items that aren't backward compatible are T-SQL commands specific to new functions in 2K5; SSIS orchestrations; any CLR stuff you may have written (and God Bless You if you already have). Information schema commands are by and large unchanged so you should be able to create a COPY DATABASE job between the instances without a problem.
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices