15 January 2009 15:19
tonyrogerson
SQL 2005 Publisher and push Subscription to a SQL Server 2008 box
My client has SQL Server 2005 and needs to publish SQL data to me, I'm running SQL Server 2008 Express.
I installed SP3 of SQL 2005 so I could connect to SQL 2008.
Could I get SQL 2005 to set up the subscription - could I heck! Well, not with the GUI anyway.
Fix: Using SQL Server 2008 Management Studio to do it - worked like a charm.
May be having a Friday moment on a Thursday; I even tried using ODBC but couldn't get that going either :)
Tony.
Filed under: SQL Server, SQL Development, Replication