| Author |
Topic |
|
V1ckV1ck
Starting Member
6 Posts |
 Posted - 2011-07-20 : 13:37:13
|
| I'm trying to find any software who can help me with the process of replication in SQL Server 2008 R2.Does anyone know of any? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-07-20 : 13:50:01
|
| What do you want it to do that SQL Server doesn't already do? Looked at the New Publication Wizard in SSMS? |
 |
|
|
V1ckV1ck
Starting Member
6 Posts |
Posted - 2011-07-20 : 17:13:17
|
| I want to do the replication, actually we have the transactional replication, but the business dont want to modify the structure of the tables (adding the index in all the tables) the option of peer to peer, mirroring and merge dont apply according the needs of the application and business. thats why the asked me to find an application or software that help us to do the replication, I find this one SQL SERVER Replication DataXtend Re, but I want to have more options. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-07-20 : 17:50:20
|
| So they don't want you to add primary keys? |
|
|
|
V1ckV1ck
Starting Member
6 Posts |
Posted - 2011-07-20 : 17:58:30
|
| no, they think that this will affect the function of the application. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
V1ckV1ck
Starting Member
6 Posts |
Posted - 2011-07-21 : 09:41:48
|
| Hi Tara!yes but there are some tables that dont have some primary keys |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-07-21 : 09:51:01
|
| Well they should anyway, regardless of whether you use replication or not. If the apps breaks, then the app needs to be fixed. Better than having a broken database.Look at it this way: you can add primary keys at no cost, and therefore use the built-in replication, or spend a lot of money on something to replicate without them. |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2011-07-21 : 10:29:08
|
I'm guessing also:If you have no primary key on the tables.... Then those tables also don't have a Clustered Index? (they could but I'm betting they don't)Having a good look at your data is a good thing.  Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2011-07-21 : 12:52:59
|
quote:
Originally posted by V1ckV1ck
Hi Tara!yes but there are some tables that dont have some primary keys
If the table has some something that makes it unique, either a single column or a combination of columns, then throw a primary key constraint over it and be done with this issue as you can now use built-in replication. It is so very silly for your company to be looking at alternative methods and puts into question everyone's level of knowledge.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
|
Software for Data Replication