Hi, I need to get data from my main sqlserver2005database to my client end sqlserver 2005 express edition daily . At the end of the day, i need to post my database from my end to main sqlserver 2005 database. How to use replication for this? How to implement it? Please provide me steps to follow.

Question

Post reply

Hi, I need to get data from my main sqlserver2005database to my client end sqlserver 2005 express edition daily . At the end of the day, i need to post my database from my end to main sqlserver 2005 database. How to use replication for this? How to implement it? Please provide me steps to follow.

n_padma

Old Hand

Points: 316
More actions
October 9, 2008 at 4:34 am

#194111

Hi,
I need to get data from my main sqlserver2005 database to my client end sqlserver 2005 express edition daily . At the end of the day, i need to post my database from my end to main sqlserver 2005 database. How to use replication for this? How to implement it? Please provide me steps to follow.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Sakthivel Chidambaram SSCertifiable Points: 5531 More actions · Answer 1

Then you need to use snapshot replication. Use this link to get some articles to help you..

Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc

n_padma Old Hand Points: 316 More actions · Answer 2

Your link is not working. Provide me the answer then.

Sakthivel Chidambaram SSCertifiable Points: 5531 More actions · Answer 3

Hi Padma,

What I gave is just link in Google Search... Try Searching for "Setup Snapshot Replication in SQL 2005"... You will get some articles... Else use this link which has steps for SQL 2000

Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc