?
Solved

Replication - Easy Question

Posted on 2007-12-04
4
Medium Priority
?
232 Views
Last Modified: 2010-04-21
Hi DB Experts!

I have a quick question regarding replication. I haven't set up a DB to be replicated before but will be doing so in the near future. My main question is, once you set up replication for a database, how much work is it to add another column to a table that is being replicated? Is it pretty trivial or more involved?

Also, if you wanted to add your 2 cents on replication I wouldn't complain. Is it pretty easy to setup and maintain? Any gotchas? I'll be finding out pretty soon. ;-)

Thanks everyone!
0
Comment
Question by:CoconutTelegraph
[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 8

Accepted Solution

by:
i2mental earned 1000 total points
ID: 20405959
Adding a new column is not a big deal. That specific ability was added in 2000. Altering an existing table can be more complicated however.

http://www.databasejournal.com/features/mssql/article.php/1478611
0
 
LVL 8

Expert Comment

by:i2mental
ID: 20405965
I meant to say altering an existing column, not table.
0
 
LVL 18

Assisted Solution

by:Yveau
Yveau earned 1000 total points
ID: 20407259
This is a good site to start:
http://msdn2.microsoft.com/en-us/library/ms151198.aspx

Adding a column in the publication is like using normal SQL statements ... wait for the next replication and the subscribed databases will get the modification as well. Can it get any easier ?

Easy to setup ? ... it's a database ... how hard can it get ?

Gotchas ... beside running MS Windows ? No :-)

Hope this helps ...
0
 

Author Closing Comment

by:CoconutTelegraph
ID: 31412661
Thanks y'all.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
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…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Suggested Courses

800 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