DTS project completed, full replication functionality deployed.

Today we launched the project I was discussing here. So far everything appears to be running properly at the one property that went live. I seem to have pushed out an older version of a SQL file, so we had to scramble to get the updated changes out there, but there were only a few lines of code to be run.

It'll be interesting to see how the project proceeds. We dubbed it "Project Plantation" we've got custom replication agents (we called them farmers, harvesters, and a few other terms) running all over the place, from the property's database, back to our primary database, and then from the primary to a secondary database we have running here in our home office.

The whole project has come together in just about a month, and it should make our in house application run a lot more smoothly for our customers, instead of one primary database we are creating smaller databases that will run off of MSDE for each of the properties, we then replicate the data from each of these properties up into our larger database, and send any other changes created by invoicing or the administration program back to each of these smaller databases. Over the next few months we'll slowly convert many of our other properties, close to 200, over to the new system. At that point it will be interesting to see how much bandwidth this is going to use up, we've already ordered a larger pipe, but I'd be willing to bet it won't be enough... We'll see though ;)