August update + SQL change compulsary?

[zag]

Just about to do the update, do I need to do the SQL change over at the same time?

[localzuk]

The SQL change is required before the November release. The august/september releases don't need it.

[enjay]

Nope, but you will need to have done the SQL migration before you apply the November update.

[zag]

Yeh great, just did the Aug update and no problems, Seems the September update is just a DVD disk of the Aug update, it contains nothing extra.

 

Push the SQL change under the rug for a few more weeks then

[ndavies]

Anyone had the cast iron unmentionables to do the SQL migration yet. I think everything is in place (just a few issues with RMs Portal PLus to sort out first).....I just don't want to break SIMS.

 

Anyone have an idea how long it will take?

 

Thanks

 

Nick

[klawd]

I Installed SQL2005 on the server, alongside SQL2000. All seemed to go well.

until users logged into SIMS for the first time, and logged out.

 

SIMS seemed unable to locate the correct SQL instance, even though no DB was detached or migrated. I ended up having to remove SQL2005 to get SIMS working again.

 

Not looking forward to the November update!

[DMcCoy]

I've done SQL2005 and FMS migration so far, all seems to be working (as much as it ever does).

 

Did you change the connect.ini klawd? The instructions are quite good. I also had to remove some lines from my connect.ini on the clients too though.

[zag]

Where are the instructions? I check capita's site but there are about 10 different hot topics on the migration!

 

Also did you need the SA password?

[ndavies]

The file on Supportnet SIMSSQL2005Migration_12873.pdf is pretty helpful and straightforward (for a change). I came unstuck when our server wasn't on SP1 at least...which took an extra hour.

 

Also when it prompted for the db to migrate, the list was empty, a solution for which was posted on here in my thread "SIMS SQL Help Needed" or something similar

 

...the guide doesn't tell you about this "feature"