Multiple SQL servers, One which is mobile...
Ok, My first time on this site and I'm loving it so far. I'm in a rut and I am somewhat new to SQL.
My question is this.
Is it possible to integrate a webpage so at a click of a button OR at least minimum search parameters you can pull SQL data from a remote server and import it to a local SQL server? If so what would you suggest be the easiest way to accomplish this(as far as programming languages)?
I assume you can query the remote server, create a temporary database and then import that into the local server. Am I close?
I know you can query the server to see the data, but the latter half of my question is where I have no idea.
My other problem is that the remote SQL server is moved a lot. It's designed to travel on ships and travels from ship to ship. Therefore I have no idea how the server is linked or even if it is linked.
I can't do a link to the remote server full time because not all of the data needs to be imported.
It should only when there is a problem on one of the ships and they need the data to review it.
I can't give any more details as I don't have them yet. This is a project in which I am being brought on board due to the last guy could only build a webpage with broken links after a few weeks. Like I said, I'm fairly new to SQL but I do know some basics. Any guidance, common links or anything at all would be greatly appreciated.
I know this is somewhat generic and I apologize for that. I just don't know where else to look.
Thanks in advance.
Thanks Hack for your help.
I was just told that the web page or interface to be built, well they want it integrated into share point if possible. Any idea which language will be better for this? I used to be proficient in java, but this whole thing is new and I am eager to learn regardless. For right now, I'm looking to see which is easier to code when connecting and transferring SQL. I've coded some SQL before, but it was a straight SQL code, no webpages where involved.
I think I'm going to Google this some more looking for examples of simple remote connection scripts. Thanks again for your help. I truly appreciate it.
Importing data to a local sql server from a remote one
I guess this can be done in many ways, but the last time I had to work on this, which is more than a year ago, we went for ssis of sql server 2005.
Basically, you have a dtsx file in your local computer. Connection strings are in a .config file provided by ssis package. We invoked this package with C# and ado.net, but I am sure it can be done with other technologies as well.
A point to notice: we didn't use a web app, but a winforms app, so the ssis package, meaning .dtsx file, was local to this machine as well as the application. This machine had a local sql server.
I hope this shed some lights over your doubts.