question

Bhupendra99 avatar image
Bhupendra99 asked

Table Sync between two not connected Sql servers

Hi I was assigned a task to sync two table from two different sql server (both are 2008 R2) There is no connectivity between them and I was not allowed to create a link server Can anyone suggest any way how can I achieve it
synchronisation
4 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Is this a one time sync or are you looking for something that is more real time?
0 Likes 0 ·
@JohnM I would guess so!
0 Likes 0 ·
@Kev Riley - that's what I thought but wasn't quite sure. We'll see if the OP responds.
0 Likes 0 ·

1 Answer

·
Tom Staab avatar image
Tom Staab answered
I would suggest using an SSIS Merge Transformation if they are at least on the same network.
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

No they are not on the same netweork
0 Likes 0 ·
What is the size of the table in question?
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.