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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Replication Question for SQL MVP

Author  Topic 

rem7600
Starting Member

1 Post

Posted - 2009-05-08 : 15:14:21
Hi All,

My question is... Is it possible to use SQL Server Express 2005 or 2008 to pull data one direction from a SQL Server 2000 SP4 Publication?

I understand that's a loaded question!

rem7600

Vinnie881
Master Smack Fu Yak Hacker

1231 Posts

Posted - 2009-05-08 : 15:24:33
Just create a linked server to the SQL 2000 database, and you should be able to pull whatever data you would like.


Success is 10% Intelligence, 70% Determination, and 22% Stupidity.
\_/ _/ _/\_/ _/\_/ _/ _/- 881
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-05-08 : 15:41:45
Sorry to barge in since I am not a MVP.

Second link here
http://www.lmgtfy.com/?q=replication+considerations+sql+server+express



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-05-08 : 16:00:38
Maybe I know the answer but I can not give the answer because I am not a MVP.


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2009-05-09 : 16:22:23
Why are you only interested in answers from MVPs? There are a lot of really competent, highly knowledgable people who may very well know the answer that you're discounting. The MVP title does not mean 'knows everything', nor does it mean 'always right'

See Jonathan's rant on this - http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/01/19/how-to-ask-a-forums-question.aspx

--
Gail Shaw
SQL Server MVP
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2009-05-09 : 20:20:47
Nor does it mean they know anything about replication. I didn't when I had my MVP, still don't. All MVP means is Microsoft recognizes your contribution to the community.
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-05-09 : 23:12:45
You can't do Merge Replication between different Version of SQL Server. You can use Express Edition only as subscribers.
Go to Top of Page
   

- Advertisement -