Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

SQL Server question

  • 12-03-2008 05:40PM
    #1
    mrhappy42
    Registered Users, Registered Users 2 Posts: 382 ✭✭


    Hi,

    I have an app that needs to be run in SQL2000 emulation mode (the customer has SQL2005 installed hence the need for emulation).

    When the emulation mode is switched on do the newer features that are in SQL2005 disapear?

    Specifically 'replication' and 'transaction log shipping'?!?

    M


Comments

  • #2
    Ginger
    Registered Users, Registered Users 2 Posts: 2,931 ✭✭✭Ginger


    Unless its a very specific 2000 feature, nearly all 2000 dbs will work fine in 2005.

    What is required in the DB that requires emulation mode


  • #3
    stevenmu
    Moderators, Society & Culture Moderators Posts: 9,688 Mod ✭✭✭✭stevenmu


    I know for a fact that SQL Server 2000 supports replication, and I'm pretty sure it's almost functionally identical to replication in 2005 anyway, 2005 improved performance and manageability, but functionally it was almost the same. I'm also 95% sure it supported transaction log shipping too.

    Anyway, I think in general for features like that where it's primarily a server function acting on the database most 2005 features are still available, it's more a case of things within the database (data types and structures, t-sql stored procedures etc) being not available.

    Edit: and like Ginger say, unless you have something you know is very SQL 200 specific, it should work fine in 2005 aswell.


Advertisement