I guess before I go into the main details. I should ask the (silly) question first. Here goes.
Can an SQL query be written to
select all records from a table in a db on a local server ... then
insert(ed) into a table in a db on a remote server ... and update(d).
Here let me say, all is connected and working fine.
I can connect and manage the dbases from the following...
SQL Server Management Studio
Visual Web Developer 2005
and last ( and definitely least)
my host sql administrator manager.
I have been attempting to structure a query in VWD to accomplish the above.
I have all pertinent info concerning both local and remote server as I can open and modify datarows in each table.
And Yes. I can manually copy and paste records from local to remote database.
But there has to be a quicker way ... (I know science has progressed that far
Anyway, if any knows the syntax for a query to accomplished this (if it is possible).
I would be soooo happy ... oh yeah, and swear eternal loyalty.