Results 1 to 8 of 8
  1. #1
    Join Date
    Jun 2006
    Location
    DC
    Posts
    123

    Unanswered: Replication Standard or Enterprise

    In setting up replication between databases do both sql installations have to be enterprise or can it be done with both sql server standard edition.


    thanks,

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Replication is included in Standard Edition.

  3. #3
    Join Date
    Jun 2006
    Location
    DC
    Posts
    123

    Standard or Enterprise

    Is there a difference in using enterprise... or standard in regards to replication... I can not find much information stating the difference in choosing an edition....
    here @ work .... the prod server they want to replicate has already been built using standard... but other... admins... say it would have to be enterprise....

  4. #4
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Quote Originally Posted by jdmarsh2g
    Is there a difference in using enterprise... or standard in regards to replication... I can not find much information stating the difference in choosing an edition....
    here @ work .... the prod server they want to replicate has already been built using standard... but other... admins... say it would have to be enterprise....
    Tell the other ...admins ... to take a hike:

    SQL Server 2000 Standard Edition

    This is a more affordable option for small-sized and medium-sized organizations that do not require the advanced scalability, availability, performance, or analysis features of SQL Server 2000 Enterprise Edition. Standard Edition can be used on symmetric multiprocessing systems with up to 4 CPUs and 2 GB of RAM.
    Standard Edition includes the core functionality needed for non-mission-critical e-commerce, data warehousing, and line-of-business solutions. For instance, all of the XML features present in Enterprise Edition are also included in Standard Edition. And while a handful of advanced OLAP features are reserved for Enterprise Edition, all data mining features and the core OLAP functionality are included in SQL Server 2000 Analysis Services in Standard Edition. Similarly, components that other database vendors charge for as separate add-on products for their highest-end editions are included in Standard Edition:
    Data Transformation Services (DTS)
    Replication (snapshot, transactional, and merge)
    Full-Text Search
    English Query
    Stored procedure development and debugging tools
    SQL Profiling and performance analysis tools
    Before choosing Standard Edition, make sure you review "Features Supported by the Editions of SQL Server 2000" in SQL Server Books Online.

    -- This is all just a Figment of my Imagination --

  5. #5
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Kindly ask the "other admins" for proof of this. Perhaps, if you build the replication into the QA system (a good idea, anyway), you can prove to them it is possible.

  6. #6
    Join Date
    Jun 2006
    Location
    DC
    Posts
    123
    I appreciate the feedback... and will do a lot more research.... any experienced suggestions or tips that a tutorial or book might not mention ..... thanks again guys....

  7. #7
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Or maybe they would like to read the 2005 features for themselves:

    http://www.microsoft.com/sql/prodinf...-features.mspx

    -- This is all just a Figment of my Imagination --

  8. #8
    Join Date
    Jul 2007
    Location
    New Jersey
    Posts
    1
    I have a solution that not only replicates the data (standard or enterprise, 2000 or 2005) but also load balances read-only statements and provides effective means of resynchronization. I work for a company, PCTI (Parallel Computers Technology Inc), out of the Philadelphia area. We have a product, DBx, that does Parallel Synchronous Real Time Replication (up to 16 servers, local or remote) guaranteeing zero-loss of transactions. Anyone looking for more information should visit http://www.pcticorp.com or send me a private message via dbforums.com.

Posting Permissions

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