Hey Gang, I have SQL Server database that I'm designing for a .Net Development application group. It's pretty cut and dry all the relationship are one to many and fully normalized. This application will interface with other application in our organization and some of the data I found is availble in Oracle which handle User info and is updated daily.

?? Can you replicate Just a portion of a table. If I want to get 5 out of 50 fields replicated from Oracle to SQL Server??