September 27, 2010 at 10:10 am
I have a customer that wants to export data from a database using a view of data. That data he wants to use snapshot replication to export and import it into another database. I don't know all the details. I haven't setup replication in SQL Server and I'm not sure if this can be done. Any help would be appreciated. This is sql 2005.
September 27, 2010 at 11:53 am
It sounds like your user is possibly confused. But here's a quick Replication primer that might help you speak to him about his needs.
In every version of replication (Merge, Transactional, and Snapshot), an initial snapshot of data is taken from the source database and applied to the destination. The only information you get is information set up as publications and articles. So if you have a publication that is only reading 5 columns from tblOrders, the initial snapshot will only send that data over.
In Snapshot replication, every time replication is run, it will take a snapshot of the source database and send the information to the database. Basically, the destination is cleared of all old data every time a new snapshot is taken.
Views can be replicated, and I think they end up as tables on the destination. But a publication and article(s) would need to be set up for this.
Books Online has more detail. Look up Replication.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply