Technical Upgrade to 5.0 SP1 using SQL2005

Alex_Chow

How do you guys recommend doing a technical upgrade to version 5.0 SP1 when the client is using SQL2005?

1. Open the database and convert it?
2. Do a full Backup, then restore the database?

If we just convert it, will it leave the unused SIFT tables in the database?

bbrown

The conversion process removes the SIFT tables.

ara3n

If you have enough time, do the backup and restore, if you don't have the time, do the upgrade route.

David_Singleton

Alex Chow wrote:

How do you guys recommend doing a technical upgrade to version 5.0 SP1 when the client is using SQL2005?

1. Open the database and convert it?
2. Do a full Backup, then restore the database?

If we just convert it, will it leave the unused SIFT tables in the database?

For a pure Exe upgrade, no change on SQL I would just connect to the DB and convert the DB. Its amazingly fast, I was very surprised at how fast the conversion goes.

kriki

David Singleton wrote:

Alex Chow wrote:

How do you guys recommend doing a technical upgrade to version 5.0 SP1 when the client is using SQL2005?

1. Open the database and convert it?
2. Do a full Backup, then restore the database?

If we just convert it, will it leave the unused SIFT tables in the database?

For a pure Exe upgrade, no change on SQL I would just connect to the DB and convert the DB. Its amazingly fast, I was very surprised at how fast the conversion goes.

Probably because dropping of the SIFT-tables is very fast. Also removing the TSQL-code in the triggers and then just create some indexed views. This is baked into SQL, so it should be a lot faster to create. And it does not create all the SIFT-levels of previous versions.