Late night, after hours, working with Wayne on a custom data migration. We had 6 corporations to move off of data 3 and onto the data 8 server. That server, data 8, has been ready for almost 6 months. We were waiting for the sales tax updates to happen and take place prior to the migration process. We finally decided to just do it. Anyways, Wayne and I jumped on and did some prep work. We started pulling data for the corps and transferring it over to the new server. We then had to go through each folder on the data 3 box and make sure that we had the latest and greatest files for the new data 8 server. That took quite a bit of time.

Towards the end of the session, we had two database tables that were giving us problems. We had to switch tools in order to get everything migrated. Then at the last second, we found out that we had one other (newer) corporation that needed to be migrated. By the time we started onto that one, the clean migration process ended and the new data 8 server started getting used by the company. The last minute request for the new corporation failed in a number of places due to duplicate id numbers. If we would have known about the seventh corporation before hand, everything would have been ok. But we didn't learn about it until users had already started working for the day and thus claiming new database id numbers. Pretty crazy.