Upgrade using SQL Server? Or C/Side database?

Alex_Chow

We have a client that's going to be upgrading to version 5.0 from 3.7. They've purchased a SQL optimized server to migrate to SQL when they're up with 5.0.

Should we run the upgrade process on SQL? Or the standard C/Side database, then backup and restore to SQL?

Are there any performance issues when running the upgrade process on SQL?

ara3n

I've always upgraded on a native db connecting the to database directly.
I've also increased the cache on the client to 120 Mb.

Marije_Brummel

There is no benefit in running on SQL I guess.

The upgrade does a lot of table changes for all records and Native is generaly faster in those type of transactions unless you have a SQL server in which the table can be cached.

IF you use SQL just unmark the rowlock sinche it will kill your lockmemory.

Good luck.[/u]

ara3n

Also if you are on sql, make it single user.

Alex_Chow

Gotcha... Most likely, we'll be doing the upgrade on the C/Side database.

Thanks for all of your feedback!

idiot

Does the native database has any size limitation in 5.0?

ara3n

There is still license limit. The one I'm looking at is 131072000 KB.