March 24, 2004 at 2:41 pm
Hi-
I had posted an earlier message about applying differential backups to large databases as a possible way to migrate my data across our firewall, as it turns out this is not going to work for other technical reasons, so I am looking at log shipping as the possible method for our database migration process. Since I am rather new to this concept (I have worked with other DBA's to implement it inside the same domain/firewall) I am looking for any articles, tips or tricks for how this would work across a firewall with only one way communication open (pulling to production).
So here is my environment. We have 4 servers. 3 inside the firewall (development, test, intranet production) and 1 in the DMZ (internet production). Currently, all databases servers are synchronized, but that will cahnge over time. My plan is to use our test environment as a 'staging' area for our changes in development. Once our applications are all testing againt this test database environment, I will need to implement the changes to our intra and internet production environment. I know I can schedule jobs to fire the changes inside the firewall, but I am concerned about the database server inside the DMZ.
So, if any one has any links, white papers, tips etc that might be able to help me out I would appreciate it.
Thanks,
Joe
March 25, 2004 at 8:55 am
Joe,
Last I checked you couldn't use log shipping as a way to deploy schema changes. 'Once our applications are all testing againt this test database environment, I will need to implement the changes to our intra and internet production environment.'
Why wouldn't you just script your changes out and deploy them directly to production?
Maybe I'm confused?
Zach
John Zacharkan
March 25, 2004 at 9:11 am
Zach,
Actually when I said changes, I meant the data changes, not any database schema changes. We are updating tables in the database and then shipping those updates across the enviroments.
Joe
March 25, 2004 at 9:21 am
Still don't see log shipping being a solution. Why not use a DTS, or a script to export and import the data. Create a link server, or backup and restore the database.
Seems to be a some confusion on why and how you would use log shipping. Again maybe I'm missing something.
Thanks,
Zach
John Zacharkan
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply