Upload Data on our Internet Hosting SQL Server

[eselhassan]

Hell everyone,

I currently have our AS400 linked to SQL Server and we are doing a nightly upload from AS40 to SQL. This process is working great and our intranet site is flying.

We need to upload some what same data into our internet hosting company's SQL server.

I'm just looking for ideas about how to go about this. One thing that I don't want to do is to let them make the request for data i.e I want be the one who send the data. How can I achieve that. All comments are welcomed. Thanks

 

[JohnDTampaBay]

You could set up a push replication process from your server to the hosting company's server.

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.

 

[eselhassan]

Hey AngelWPB could you please point me to a document or something about how to set up such a process. That would be great. I'm still open for more ideas. Thanks

 

[JohnDTampaBay]

Check out replication, overview in Books Online, loads of information.

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.