Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Flaterik
Starting Member
26 Posts |
 Posted - 2012-03-05 : 11:11:51
|
| Hi people i have a big problem.I have a SQL 2008 Server with a DB that have a replication to other server.This DB is the DB of our Management System. We create a replication to use this DB for our E-Commerce (we take users, articles etc etc). We must use this system becaus the Company connection is not so fast , so we must replicate the data on online server with another db that is simply the replication of the business DB with other Custom Field and Custom Table.Wher's the problem, whene we update the company management system, the replication must be disabled. The update delete all and reconstruct the structure of DB. How we can reuse the replication? Re-Create replication cause us a big problem becaus of the Reneizalization of the Snapshot, delete all the data of the online db so we lost the custom Field that we have used on some table.How to resolve? Other way to use the internal db on online server?Thank you very Much************************************************the world is strange but people are crazy |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-03-05 : 15:52:42
|
| In the article properties, under destination object, action if name is in use, choose Keep existing object unchanged. |
 |
|
|
Flaterik
Starting Member
26 Posts |
Posted - 2012-03-06 : 06:29:20
|
| Thank you for reply but i don't understand it very much.For example if the field exist, doesn't overwrite it with the snapshot? But then when i want to update that table?I want to update the table with the data from DB of management system, but i don't want that the field i create in this table only in the online database are modified************************************************the world is strange but people are crazy |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-03-06 : 11:23:14
|
| I don't understand your question. Your other option is to restore a backup on the subscriber and initialize without a snapshot. |
|
|
|
Flaterik
Starting Member
26 Posts |
Posted - 2012-03-06 : 11:45:35
|
| My Question:If i select Keep existing object unchanged , the replication doesn't modifiy my object Never or only on the first Snapshot?Because i want to keep unchanged the object value only for the first snapshot, but then if the object on server change somo article line, the change must be replicated on the online object.Restore a backup on the subscriber could be a good idea. How i can initialize without snapshot?************************************************the world is strange but people are crazy |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
|
|
Flaterik
Starting Member
26 Posts |
Posted - 2012-03-08 : 05:42:07
|
| Thank you for reply, i solve the problem with the second solution!Thank you very much!************************************************the world is strange but people are crazy |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-03-09 : 13:21:03
|
| You're welcome. Glad it worked out! |
|
|
|
|
|
|
|
|
[SOLVED] Replication and System Update