April 17, 2009 at 7:39 am
Let me start by saying, if this is not the right place to post this question I apologize in advance; please redirect me.
Scenario: I have SQL Server 2005 that runs using Windows Authentication Only, I have SQL Server Express 2005 that is used for our Public Website running Mixed Mode. On our public website we have a survey consisting of 10 questions, that writes the data back to the SQL Server Express. I want the data that is written to sql server express to write (replicate) to the SQL Server box each time a survey result is written to the sql server express box.
I can see the data using Linked Server, but I need the data to actually reside on the SQL Server box so that I can use it with another software program that cannot read the data from the sql server express because of licensing issues. Is replication the way to do this? If so, how?
Thanks in Advance,
April 17, 2009 at 8:14 am
Scenario: I have SQL Server 2005 that runs using Windows Authentication Only, I have SQL Server Express 2005 that is used for our Public Website running Mixed Mode. On our public website we have a survey consisting of 10 questions, that writes the data back to the SQL Server Express. I want the data that is written to sql server express to write (replicate) to the SQL Server box each time a survey result is written to the sql server express box.
You actually don't qualify for replication because Express can only be a subscriber and not a publisher, so you will need to run for pay edition on the web so a local Express can collect the data for you.
The Win2008 Small business Server comes with SQL Server Standard free.
Kind regards,
Gift Peddie
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply