April 6, 2012 at 6:19 am
Hi
Can anyone point me in the right direction for any info on replicating SQL 2005 standard data on my desktop pc and publishing the data to my VPS which has SQL2008R2 Express installed.
As all examples i have seen just involve replicating data from local to local db's
Thanks
George
April 6, 2012 at 10:08 am
gwphillipson (4/6/2012)
Can anyone point me in the right direction for any info on replicating SQL 2005 standard data on my desktop pc and publishing the data to my VPS which has SQL2008R2 Express installed.
I understant that because Express Edition does not includes SQL Server Agent the main problem would be on that side - anyway you can use task scheduler to run an RMO program.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.April 6, 2012 at 1:15 pm
Hi PaulB
Is that Replication Management Objects Concepts?
http://msdn.microsoft.com/en-us/library/ms146869.aspx
Also would it be possible to install sql 2005 onto my VPS server from my desktop, if so how would i go about doing that?
Regards
George
April 6, 2012 at 1:58 pm
gwphillipson (4/6/2012)
Hi PaulBIs that Replication Management Objects Concepts?
http://msdn.microsoft.com/en-us/library/ms146869.aspx
Also would it be possible to install sql 2005 onto my VPS server from my desktop, if so how would i go about doing that?
Regards
George
1- Yes.
2- VPS is nothing but a virtual machine running in a hosting facility therefore - provided that your hosting service provider allows for it and you have the credentials and needed license you can install SS2K5 there.
During SQL Server installation, setup program - running on your desktop - will ask for "Computer Name", default is "Local Computer" (or something similar), you have to type in the name of the remote computer or browse for it then just install as you normally do.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.April 6, 2012 at 3:16 pm
Hi Paul
Thanks, will try it
George
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply