This was obviously asked a while before V3.4 was this close to release, so I want to verify that nothing has changed. Is this still a valid procedure when upgrading from V3.1SR2 and Access 2000?
point 3 specifies to run setup.asp?rc=5, you will no longer need to add the ?rc=5 when upgrading with 3.4.
There are some new tables in 3.4 so it may however be better to import the data to sqlserver prior to running setup.asp and do an "upgrade" rather than a new install. I haven't had a chance yet to test this myself.
I basically did the same but from Access to a MySQL db. What I did was convert my access database to a mysql database, then afterwards I do the upgrade.
It's always the best thing to let the setup file create or upgrade the database. Instead of upgrading the access database then importing it into the sql database.
Then again, I have no experience with sql databases. Not that you should totally ignore my post though.
I've already tried this both ways. You can upgrade your Access database to 3.4, setup a clean SQL Server 3.4 database and then DTS the whole data. However, you can also setup a clean SQL Server 3.3 database, DTS all your Access 3.3 data and then upgrade your SQL Server 3.3 database to 3.4, by executing 3.4's setup.
I see no meaningful difference between both. Personally I prefer upgrading my Access DB before, have my first go with the forum on an Access DB and then create the SQL Server Db. It's just a matter of personal preference really...
Topic Locked
Posted - 09 August 2002 : 02:20:04
