I have had much more success in migrating CODBs when running CF5 vs. CF451. I have also had much greater success when Spectra 1.51 was pointing at new 1.51 cfaobjects rather than a 1.01 cfaobjects that was migrated forward.
Ray's suggestion of using a 'reduced' CODB seems to make sense also. Regards, Ken Smith Senior Engineer Spectra Product Support -----Original Message----- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 8:48 AM To: Spectra-Talk Subject: RE: Migrating large DB from Spectra 1.0 to 1.5.1 What you may want to consider is upgrading only a shell of your site. Ie, copy your DB. Delete all the instances of your custom types. (Ie, articles, etc.) That will most likely take your 4 gig DB and drop it down to < 1 mg. Upgrade that. Then, write a script to grab data from the old DB and make new Spectra objects out of them. This script will still be very slow, but, you could do things in portions. I.e. (and this is pseudo-code): grab 500 records from old db using simple sql make new objects out of them delete the records you just got This way, you could run your script again and again until eventually, all of the old instances are now in the new DB. ======================================================================= Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -----Original Message----- > From: Robin Anne Pentola [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, November 13, 2001 1:20 PM > To: Spectra-Talk > Subject: Migrating large DB from Spectra 1.0 to 1.5.1 > > > I've been trying to upgrade a relatively large (4 Gig) DB from Spectra > 1.0 to Spectra 1.5.1. When I run the upgrade process through the > webtop, it makes it to Step 43 (starting > userprofilemigration) and then > dies in its tracks. > > The webtop tells me only: > an error has been deleted while upgrading these data sources: (db > name). The wizard will continue and probide a report upon completing > the upgrade. > > Then nothing. The browser either throws an error that there > is no data, > or goes blank. > > I have deleted the DB, restored, and re-attempted the upgrade process > three times. Similar results each time. > > What can I do to get past this issue? Thanks in advance, > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm ------------------------------------------------------------------------------ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
