Data replication ASP/XML Solution needed

Question

Data replication ASP/XML Solution needed

Nick Kernick

SSC Rookie

Points: 34
More actions
November 18, 2009 at 9:08 am

#213913

Well i have spent two days on this and Iam going around and around in circles.
I have two SQL server Express boxes sat on the net. Both are not open to the internet. They only accept local connections. So i cannot connect the two.
I want to replicate one table from (1) SQL Server to Another.
I have looked at using ASP to create XML files , of which microsoft iis/asp is extremely fussy about the fields i have stored.
I thought the easy answer would be to create an XML file on server (1) and have server (2) read and upload the data. I just keep getting stone walled with Encoding errors etc...
Has anyone done this, and have they got an easy solution for it.
kind regards
Nick

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Gift Peddie SSC Guru Points: 73570 More actions · Answer 1

You can convert the User instances to server instances and use other SQL Server in your network to create replication using the two as subscribers. The Express can be a subscriber in all replications.

http://blogs.msdn.com/sqlexpress/archive/2006/11/22/connecting-to-sql-express-user-instances-in-management-studio.aspx

Kind regards,
Gift Peddie

Nick Kernick SSC Rookie Points: 34 More actions · Answer 2

Thanks for your reply, however iam new to this

The servers sit on the internet in their own little world. They dont talk to each other.

and dont think they can be connected to other than by a browser or Remote Desktop

hence why i thought about creatingf CSV or XML files.

i wanted it to work seamlessly

Gift Peddie SSC Guru Points: 73570 More actions · Answer 3

Nick Kernick (11/18/2009)
Thanks for your reply, however iam new to this
The servers sit on the internet in their own little world. They dont talk to each other.
and dont think they can be connected to other than by a browser or Remote Desktop
hence why i thought about creatingf CSV or XML files.
i wanted it to work seamlessly

I don't know where the people got that but SQL Server Express run as a server instance with the browser service running is like any SQL Server with 4gig per database restriction. In you are in SQL Server 2005 go to the SAC(surface area configuration) tool and enable a lot of disabled features. You or a skilled person can connect them and pull the data you need. If you are in 2008 then you go into configuration manager.

Kind regards,
Gift Peddie

Nick Kernick SSC Rookie Points: 34 More actions · Answer 4

right im being totally thick here. I dont want to "open" up an sql services to the internet

i have had servers totally ruined by people hacking into sql services when they were open.

i just want one server to call another , and access a feed. But dont know how to do this.

thanks, i know im being thick here

Gift Peddie SSC Guru Points: 73570 More actions · Answer 5

Nick Kernick (11/18/2009)
right im being totally thick here. I dont want to "open" up an sql services to the internet
i have had servers totally ruined by people hacking into sql services when they were open.
i just want one server to call another , and access a feed. But dont know how to do this.
thanks, i know im being thick here

I don't share your concern but here are two options one either use BCP to move the data you need or upgrade your SQL Server Express both 2005 or 2008 to Express with Advanced Services it comes with an import/export wizard you can manually use to move your data. If you are in 2005 then you need the one with SP3 and in 2008 one with SP1.

http://msdn.microsoft.com/en-us/library/aa337544.aspx

http://www.microsoft.com/downloads/details.aspx?FamilyId=B5D1B8C3-FDA5-4508-B0D0-1311D670E336&displaylang=en

Kind regards,
Gift Peddie