I'm planning to setup transactional replication from a remote SQL 2000 server (Standard Edition) (publisher) and a local SQL 2005 (Standard Edition) server (subscriber).
The replication only needs to be one-way (from publisher to subscriber). The link between the two is a shared 2Mb SDSL line, which has heavy use so can be fairly slow.
My questions are:
1. Is transactional replication possible from 2000 to 2005, in the STANDARD editions?
2. We want the subsriber database to be updated fairly regularly throughout the day. Which replication method would you recommend given my requirements? Snapshot, transactional or merge?
3. I understand that when you setup transactional replication, it creates another database (pubs). Is that correct? I'm sure I read somewhere that it will change the structure of the database being subscribed to - is that true? I don't want my source database to change!
4. Finally we want to be able to run reports etc (read only) on the subscriber database (thus taking the load off the remote database). Will this be possible? Or will the subscriber database be in a constant 'updating' state?