sql server

[arial]

Hi,

I have new project comming up to transfer SQL server data from one server to another sql server wirelessly. Both the servers are at different location and on different network right now and data needs to be moved between them wirelessly.

Can someone point out where can I get more information on this?
like some articles,web portals etc.

Thank You,

[Shashi Sadasivan]

Im not sure is SQL express can do this. Hope you are with SQL Server (atleast the development edition)

you can access the other sql serer from your sql management studio. If you can make that connection, use the task option for that database to import data, and you can import data directly from SQL server to SQL Server

Alternatively, if you cant establish a connection to the remote sql server, then you may want to use the export data functionality to an access or flat file(CSV) and then manually send it to the remote server to be imported!

If you also notice, you had posted this thread in the .Net forum. I am moving this to the SQL Sever forum where experts there can give you more help with your question.

-Shashi

[arial]

Thank You Shashi for your suggetion.
Yes, I have sql server development version.

But, I have one column to check on moving data.
like when column "Transport" equals transported then I am moving data to another sql server.

[ck9663]

Thank You Shashi for your suggetion.
Yes, I have sql server development version.

But, I have one column to check on moving data.
like when column "Transport" equals transported then I am moving data to another sql server.

what do you mean "column to check on moving data" ??

-- CK

[arial]

when data is entered in database, I have to check if one of the data field value equals "Transporte d" then i have to fire a trigger to move data.

[ck9663]

when data is entered in database, I have to check if one of the data field value equals "Transporte d" then i have to fire a trigger to move data.

let me see if i got this right...

you have tableA in serverA. if the tableA.FieldNam e = 'Transported', transfer this record to serverB.

if that's about right, you can proceed and read this. if not, then am wrong and we need more info...

if this is manual, use DTS - Import Data. Instead of importing a table object, choose the query option where you can specify what record will be transfered. type in your query with the required filtering/condition

-- ck