Solved

Replication Using Developers Edition Of SQL Server 2005 and replicating push to SQL Server Cluster?

Posted on 2007-04-10
4
214 Views
Last Modified: 2010-03-19
Greetings,

If you plan to use SQL Server 2005 replication from a developers edition to replicate data to a SQL Server Cluster Db server, wouldn't this cause some performance issues? Especially if failovers a random? Also is replication from the developers edition compatible with replication to Enterprise Edition of SQL Server 2005 Cluster?
0
Comment
Question by:Omega002
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 50

Expert Comment

by:Lowfatspread
ID: 18881817
>>If you plan to use SQL Server 2005 replication from a developers edition to replicate data to a SQL Server Cluster Db server,

check that this is a legal use of the developers version... its not supposed to be used for production systems...

>>wouldn't this cause some performance issues?
nothing more than any other form of replication

>>Especially if failovers a random?
don't understand your comment... its what its designed to do/deal with


>>Also is replication from the developers edition compatible with replication to Enterprise Edition of SQL Server 2005 Cluster?

yes its the same.. but see my first question over wether you will be licensed to do this...

0
 

Author Comment

by:Omega002
ID: 18882403
If you fail over during a replication push from the standalone server, would this cause something to hang on the Cluster?
0
 
LVL 16

Accepted Solution

by:
rboyd56 earned 500 total points
ID: 18883219
<If you fail over during a replication push from the standalone server, would this cause something to hang on the Cluster?>

It should not cause any to hang on the cluster. The replication job would fail and then restart when SQL Server came back on line.
0
 

Author Comment

by:Omega002
ID: 18889257
Lowfatspread you mentioned that replication from a developers edition of SQL Server is not supported when
replicating to Enterprise edition of SQL Server Cluster. Do you have any documentation stating this? Also does it make logical reasoning to replicate data from a Standalone developers addition of SQL Server to a production Enterprise Edition of SQL Server Cluster?
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question