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.
| Author |
Topic |
|
laddu
Constraint Violating Yak Guru
332 Posts |
 Posted - 2010-05-01 : 21:00:00
|
| Hi,Recently we have got a new project. We are developing new project with our existing database application. We are using SQL Server 2005 std edition. Now client is asking to have the database at their end. He is asking to setup a snapshot/transaction replication from our database to their database(they are also using sql 2005-not sure edition). I have 2 questions1.what are the options other than replication to fit in this scenario.2. Regarding configuring REPLICATION: What are details I need from client to set up subscriber(different location).Thank you.. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2010-05-02 : 14:14:30
|
| I have configured replication with in our server. If subscriber is in different location, how to connect to it |
 |
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2010-05-02 : 20:04:02
|
| I got the details. Both servers need to use same port to connect over network. And a account with sysadmin permission to connect to distributer.And disable identity columns in subscriber after replication configurationPlease correct me if i am wrong. Thanks!! |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2010-05-02 : 23:41:10
|
| >>And disable identity columns in subscriber after replication configurationyou dont need to do this. Just run an ALTER TABLE.. NOT FOR REPLICATION on each of the tables. you can generate this statement dynamically for all tables..and execute it.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2010-05-03 : 10:58:12
|
| Is it possible to configure replication from publisher(sql 2005 std edition) to subscriber (sql 2005 enterprise edition/express edition) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2010-05-03 : 17:30:30
|
| oh..then how to connect a subscriber, which is in different location(not in same domain) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Import data--Replication