November 24, 2008 at 12:37 pm
I am new to SQL, and am working with SQL Server 2005. I currently work with a database that exists on a remote server and would like to replicate portions of this database on my machine so that I can have access to data even without internet access.
Database A is the remote database - contains data going back 25+ years, but is updated in real time to reflect the most current data.
Database B is the database on my computer - I want it to contain data from only a few of Database A tables, and only going back 4 years. This also needs the ability to be updated daily to add in all the 'new' data that was added to Database A.
I've copied over the main portions of Database A to B, but would like to know if anyone has a recommendation on how best to update Database A (probably daily or 5x per week). Is there some sort of script I should write? Any guidance on this would be greatly appreciated.
Thanks!
November 24, 2008 at 12:58 pm
You can do transactional replication. If you do search on sqlservercentral right side top corner you will find good articles about replication.
November 24, 2008 at 2:51 pm
From what I'm reading about transactional replication, it would seem that the remote Database A would have to be set up as a distributor and the publications created there.
I only have READ access to this database, so cannot set up that kind of distributor/publication setup.
Is there another work-around, or am I misunderstanding the distributor/publication relationship? My apologies if I'm not understanding, this is definitely all new to me.
Thanks again!
November 24, 2008 at 3:51 pm
Ok in that situation, my guess would be to create script to read data from remote database and update your database. Schedule to run that script every evening, so that you will have updated data.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply