[sims] New SIMS Server Questions

[DSapseid]

Im in the process of creating a brand new domain on Server 2016 and W10 which is all fine. Its the new SIMS server that i just have a few uncertainties about.

 

Current server is 2008R2 and SQL 2012. New server is 2016 and will be SQL 2016. Am i correct in thinking that i just install SIMS and SOLUS3 that i download from the Capita website. Detach the database from the current sims server and then reattach it using the SIMS dbattach tool to do this?

 

Will there be any issues with it going from SQL2012 -> SQL2016?

 

The server my s: drive is on is currently not the sims server and sits on a file server. Is this still best practice or can it be on the new SIMS server?

 

I use the Parent/Student app so i will need to reinstall the SIMS Services Manager when i reconnect the new server to the parent app will i have to re-provision all the users or will they keep working fine? Id like to think that by using the same SIMS Database and the same SIMS Link code from the Admin Panel for Parent app that it would just work but i like to double check so I'm not met with any surprises!

 

I don't use FMS or Discover so haven't got to worry about them.

 

Any help would be much appreciated!!

[timbo343]

You may have to upgrade your database first to SQL2016 and then move the database. I had to do that whdn moving from SQL2012 > SQL2014.

[5tu]

Im in the process of creating a brand new domain on Server 2016 and W10 which is all fine. Its the new SIMS server that i just have a few uncertainties about.

 

Current server is 2008R2 and SQL 2012. New server is 2016 and will be SQL 2016. Am i correct in thinking that i just install SIMS and SOLUS3 that i download from the Capita website. Detach the database from the current sims server and then reattach it using the SIMS dbattach tool to do this?

 

Will there be any issues with it going from SQL2012 -> SQL2016?

 

The server my s: drive is on is currently not the sims server and sits on a file server. Is this still best practice or can it be on the new SIMS server?

 

I use the Parent/Student app so i will need to reinstall the SIMS Services Manager when i reconnect the new server to the parent app will i have to re-provision all the users or will they keep working fine? Id like to think that by using the same SIMS Database and the same SIMS Link code from the Admin Panel for Parent app that it would just work but i like to double check so I'm not met with any surprises!

 

I don't use FMS or Discover so haven't got to worry about them.

 

Any help would be much appreciated!!

 

I've just done this. Capita have released a SQL 2016 Migration Tool for this purpose. Our local support unit gave me the url to download this from - not sure if I'm allowed to share it here though.

 

I believe your S:\ drive contents can reside anywhere - just secure them with restricted permissions as per normal.

[Banjo]

Don't forget to move your DMS across. I usually map a temp drive between the old and the new servers to move the install\DMS files across. There is no harm is mapping the S: drive back to your new server. I've never had an issue with attaching an SQL 12 SIMS db to either SQL 14/16 or even to 17 (for testing) straight off. I've only used the migration tool when we have sheduled a move of a bunch of schools overnight. Its also worth downloading and installing SQL Management Studio is case for some reason the DB doesn't attach and gets 'hung up' and SIMS 'Db attach' won't remove it.

 

I install SQL\Studio remotely from an automated script (section below), otherwise check to make sure you have the right settings\permissions enabled.

 

/FEATURES=SQLENGINE,REPLICATION,CONN,BC /SQLSVCACCOUNT="SYSTEM" /SQLSVCSTARTUPTYPE=AUTOMATIC /SQLSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS" /AGTSVCACCOUNT="NT AUTHORITY\Network Service" /SECURITYMODE="SQL" /ADDCURRENTUSERASSQLADMIN=True /TCPENABLED=1 /NPENABLED=1 /IACCEPTSQLSERVERLICENSETERMS