replication step by step - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Replication (2005)

replication step by step

Author

Topic

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2007-09-13 : 01:32:22

Dear Experts,
please guide me for replcation.....
i'm using sql server 2005 server tools developer edition. my OS is professional 2000.
and i've sqlserver 2000 client tools also

i've two databases in my machine. publisher is in different instance, and the transactions might be maximum 50 per day. my aim is when ever developer enters the data into the main database, automatically it should be updated on the my two databases also.
i mean the server is sysA and the database is srtp.
my machine is sys20 and the databases are srtp1, srtp2.
how should i make sysA as publisher?
i've right click on the server databases, but it is showing newsubscriptions option only.

Vinod
Even you learn 1%, Learn it with 100% confidence.

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2007-09-13 : 01:47:00

can i work on replication only with client tools, even i've client tools only, i've full powers like create or drop or anything...

Vinod
Even you learn 1%, Learn it with 100% confidence.

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2007-09-13 : 05:12:45

i've created merge replication on other instance, both publisher and subscriber are in the same instance. in the publisher, i've 99 tables...but in my subscriber the tables are only 77. i dont know why???
not all the things will be same and as it is???

Vinod
Even you learn 1%, Learn it with 100% confidence.

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-09-13 : 12:02:56

Now, are you trying to get your source data into both the databases on your server? or does the data have to be massaged into 2 separate databases?

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-13 : 23:21:14

Did you create snapshot first?

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2007-09-14 : 01:17:01

Dinakar,
i'm trying to get my source data into both the databases on my server

Vinod
Even you learn 1%, Learn it with 100% confidence.

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2007-09-14 : 01:18:12

quote:
Originally posted by rmiao

Did you create snapshot first?

i need to create a snapshot at first?
i dont know......
and can i create snapshot and transactional replications on the same publisher?

Vinod
Even you learn 1%, Learn it with 100% confidence.

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-09-14 : 12:41:56

quote:
Originally posted by sunsanvin

Dinakar,
i'm trying to get my source data into both the databases on my server

Vinod
Even you learn 1%, Learn it with 100% confidence.

so you want 2 db's that will be exactly same on the destination server?

You can always set up multiple subscribers to a publication.

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-15 : 00:03:25

There is option to create snapshot when setup transactional replication.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources