sql server replication

I need to setup replication in standard edition.

my requirement is:
 1. I have server A .it contains 10 tables (Like A1,A2,A3.....A10).
2. i have another server B. it is backup of server A but it contains only 5 tables, coz i need to replicate only 5 tables (table names like A1,A2..A5).

I want to replicate changes from server A to B (only 5 tables not all 10 tables).

1. Is it possible in replication (The replication method may be merge/snapshot/transactional.)?
2. Is it possible in Standard edition?

please respond ASAP.
srinivas_ganamurAsked:
Who is Participating?
 
St3veMaxConnect With a Mentor Commented:
Yes it's possible.

You decide what frequency you want the data replicated (For near-instant, use Transactional), then create your publication and then create a subscriber (Target) and away you go.

Yes it's possible in Standard.

Cheers
0
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
>1. Is it possible in replication (The replication method may be merge/snapshot/transactional.)?

yes. replication "articles" contain tables, not the entire database necessarily

>2. Is it possible in Standard edition?
http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx
so, answer is yes
0
 
RiteshShahCommented:
>>1. Is it possible in replication (The replication  method may be merge/snapshot/transactional.)?<<
It is possible in transactional replication. here is small help:

http://www.exforsys.com/tutorials/sql-server-2005/sql-server-configuring-replication.html


>>2. Is it possible in Standard edition?<<
Yes, It is possible.

0
 
srinivas_ganamurAuthor Commented:
--
0
All Courses

From novice to tech pro — start learning today.