It depends on the setting. It will have been set when adding the article to the publication.

The default is to drop and recreate the table but you...

Another idea I've thought of is you could use a logical database (views) merging the physical databases. This would work as a testbed as well if you pursued the idea...

C.K.Shaiju (6/1/2012)

---

Hi ScottPletcher, Yes object...

Replication doesn't just change schema randomly.

It would require someone to modify it by releasing a change or editing the table structure through ssms. Might be worth checking...

Should probably also point out that I use a dedicated SSIS server which stores the packages in MSDB

Never been a problem for me. My SSIS server is still SQL 2005 has no problem running against the rest of the environment which is 98% 2008R2 =, 1%...

Marios Philippopoulos (5/31/2012)

---

We had taken copies of the system-db data and log files, as well as the folders with the SQL binaries.

We had also taken backups of all users dbs...

C.K.Shaiju (5/30/2012)

---

Hi Guys,

I need a help.

Customer requirement is to merge 3 to 5 databases to a single database. Before proceeding to this I required to know the current details (Configuration,...

True. Its just my preference....

pjl0808 (5/23/2012)

---

Thank you. I appreciate that info.

BTW: I'm not trying to gloat about the size of the table or anything, just trying to emphasise we can't...

Perry Whittle (5/22/2012)

---

you could also log ship...

pjl0808 (5/23/2012)

---

I'm testing the code on a dev server.

The "exec sp_addsubscription @sync_type = 'none' @article='all'...." is failing because I haven't dropped the subscription, I just dropped the article from the...

I've done a number of these table switches with large tables of up to 5 billion rows.

Its these proc calls

exec sp_dropsubscription @article ='bigtable'.....

exec sp_droparticle

/* drop and rename here */

exec sp_addarticle

exec...

michael vessey (5/21/2012)

---

yep - you need to drop and add the subscription for that table only. - although the article has the same name i think it gets a different...

In a real world scenario. Just think of it like you're flicking through an index of a book for a postcode, if you want more than just the postcode you...