January 27, 2010 at 11:29 pm
Hi all,
I like to setup replication on SQL Server 2008, please provide me links/topic for setting up a replication on 2008 Server, I have two sql server instances on 2 different machines.
Can it possible to setup /delete replication on server with SQL scripts.
Thanks
Mohammad Irfan
http://matespoint.blogspot.com
http://www.irfit.com
January 27, 2010 at 11:47 pm
Know everything about replication links below:
http://msdn.microsoft.com/en-us/library/ms151314.aspx
Look at Replication Wizard...
You can very well setup/delete replication using scripts. Easiest way to get this script is setup replication using wizard and then you can easily generate script from SSMS.
Additionally you may find below link useful.
http://www.replicationanswers.com/default.asp
Best of luck.
January 28, 2010 at 11:18 pm
jshailendra (1/27/2010)
Know everything about replication links below:http://msdn.microsoft.com/en-us/library/ms151314.aspx
Look at Replication Wizard...
You can very well setup/delete replication using scripts. Easiest way to get this script is setup replication using wizard and then you can easily generate script from SSMS.
Additionally you may find below link useful.
http://www.replicationanswers.com/default.asp
Best of luck.
Thanks, I am creating the scripts, still thinking how to come over the security..
Mohammad Irfan
http://matespoint.blogspot.com
http://www.irfit.com
January 29, 2010 at 5:55 am
Mohammad Irfan-488206 (1/28/2010)
Thanks, I am creating the scripts, still thinking how to come over the security..
What part of security are you concerned about? Maybe someone can help you...
-Roy
January 29, 2010 at 6:03 am
Roy Ernest (1/29/2010)
Mohammad Irfan-488206 (1/28/2010)
Thanks, I am creating the scripts, still thinking how to come over the security..What part of security are you concerned about? Maybe someone can help you...
In the scripts I see , we neeed to provide the password for setting up the server, is there any secure way to setup the replication without password and also if the password expires for that account it will take automatic or need to refresh the password into the replication setup also?
Mohammad Irfan
http://matespoint.blogspot.com
http://www.irfit.com
January 29, 2010 at 6:14 am
If I am not mistaken the only password you have to provide is the SQL User the system uses when setting up distributor and publisher. It is more like set it up and forget it kind of password. Rest of them just use Windows Authentication. Then you do not need to provide the password.
You could set it up in your DNS saying not to expire the password for the Windows logins that you are using for replication.
If you set up different windows login for Publisher, distributor and Subscriber you can manage the permissions for each separately making it more secure.
-Roy
September 13, 2010 at 7:01 pm
Is it true that I don't have to explicitly set the Not For Replication property on foreign key/check contraints, identity columns, and triggers on subscriber because during replication these contraints are automatically ignored at least in SQL Server 2008 environment?
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply