Solved

Replication - Easy Question

Posted on 2007-12-04
4
202 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
  • 2
4 Comments
 
LVL 8

Accepted Solution

by:
i2mental earned 250 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 250 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
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…
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.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

815 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now