Sending Remote SQL Queries

[eldred75]

Hi

I want to know how one goes about sending a remote query. I want to be able to do a select statement from our national server and insert the data into another table on a remote sql server (our branch servers)

Has anyone got an idea, I know I need a connection string, jdbc:sqlserver://propicanal.dyndns.org:1433;databaseName=propertyi; username; password; and perhaps my connection string ?

Need help please, any clues, links ?

Thanks

 

[ptheriault]

Use DTS...
Right click on that you want to export the data from and select export data. The wizard will walk you through the steps to export the data. just make sure you select export using a query on the third step.

 

[eldred75]

I don't think Microsoft 2005 SQL Express edition supports DTS. Is there something called RSPT - remote SQL Push Through ?

 

[ptheriault]

Your right, I didn't which version you were on.. I should have asked. Are both servers Express edition? I haven't worked with expres yet so I don't think I'll be able to help you here.