May 17, 2012 at 9:47 am
Hello All,
I am trying to set transactional replication. Publisher and distributer are on the same server, which is SQL2005. Subscriber is SQL2008. I am getting version compatibility error. I don't want to install SQL 2008 management studio to set replication. what are the other option I have?
May 18, 2012 at 2:39 pm
I might be misunderstanding your issue. The issue you are having is that you don't want to install SQL Server Managment studio 2008 on you local machine? What version of SSMS 2005 are you currently using? I take it you cannot connect to the SQL Server 2008 machine with your SSMS 2005?
You can always script out the replication.
May 21, 2012 at 8:00 am
I am running SQL server 2005 with sp4. I can't setup replication from SQL 2005 to SQLserver 2008 (which is subscriber). I am trying to set push replication. I know if I install 2008 SSMS on local server, I should be able to set up replication which I don't want to do. I am looking for other option. I was using gui to setup replication.
Thanks
May 21, 2012 at 2:02 pm
It sounds like you are logged into the server directly, is this correct?
I don't typically log into the server. I run SSMS from my desktop and connect to the servers from there. In which case I have multiple verions of SSMS but mostly use 2008R2 as it is the lastest even though we only have 2 servers out of 100+ that are 2008R2. Most are 2005.
Now if this is still not a suitable option then you should be able to log into the subscriber (2008) and use that version of SSMS to create the subscription. It is not the best solution but is a workaround.
I would really suggest to use the sp_addsubscription procedure.
http://msdn.microsoft.com/en-us/library/ms181702(v=sql.90).aspx
If you still have an issue then you will probably need to look the publication rather than SSMS.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply