April 19, 2010 at 4:55 am
I have table on remote server da.Now I want to get the table with containing values.. what should I do. I know to get table structure, but i dont know to get value of table. By getting that I have to use that table in my local db.
April 19, 2010 at 5:41 am
It depends on how often you want the data refreshed, if the table is being written to in both locations and what kind of link you have between the two sites.
If its data being written to on one side only and you just want a copy of that data on a weekly/nightly basis i would just write an SSIS package to copy the data over based on an entrydate field.
If its data that is being updated on both sides and inserted at both sides i would look at some form of replication.
You will probably have to tell us a little more about the data, how frequently its updated and how much of it there is to give you a "proper" answer
April 19, 2010 at 6:47 am
I'm not entirely sure I understand the question, but you could use SSIS packages, as suggested, to move the data on a regular basis, or you could set up replication to copy the data from the source to the target... there are other choices that might make sense as well. You'll need to be more specific about the issue to get more specific answers.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply