[sims] Duplicate sims database

[mrbios]

Hello chaps,

 

I want to create a copy of my sims database on a different SQL server for testing purposes, but i feel there's a step somewhere that I'm missing as i can't seem to do it....

 

I went to my other SQL server and went to restore last nights backup to it with a different database name which worked successfully, it created all the sims users, albeit as disabled users on the server, i've redirected my connect.ini to point at the test one and i've enabled mine but i can't login to it. I've fiddled about with the various login settings but i cannot get it to let me login .

 

Is there anything special i need to do in order for the logins to work correctly?

[glen_j]

I believe the passwords are not stored in the sims database and need to be copied to it by running a script/ query.

 

found the query

SIMS

Code:

osql -S%COMPUTERNAME%\SIMS2008 -Usa -Psa_password_here -n -Q"exec sims.sims.db_p_transfer_login"

FMS

Code:

osql -S%COMPUTERNAME%\SIMS2008 -Usa -Psa_password_here -n -Q"exec ccsfms.sims.db_p_transfer_login"

[vikpaw]

Have you installed SIMS to that server, or are you just moving the sql.

I think you'd need to have it setup like a clone of the current system , or actually install the SIMS server components.

 

Then the transfer logins code would also work. A restore usually pushes the logins to the master table, assuming at some point they have been transferred into the database, either by the code or a detach using the dbattach.exe would do it.

 

This might be worth a read:

http://www.edugeek.net/forums/mis-systems/139296-very-stressed-sims-invalid-username-password-all-users.html

[mrbios]

Have you installed SIMS to that server, or are you just moving the sql.

I think you'd need to have it setup like a clone of the current system , or actually install the SIMS server components.

 

Then the transfer logins code would also work. A restore usually pushes the logins to the master table, assuming at some point they have been transferred into the database, either by the code or a detach using the dbattach.exe would do it.

 

This might be worth a read:

http://www.edugeek.net/forums/mis-systems/139296-very-stressed-sims-invalid-username-password-all-users.html

 

Hmmm good point, i was just moving the sql but i guess i need a whole separate setup.

 

Apparently we have a new dicipline management system being put in place and the ladies who manage all that want to change things in sims to test it all out, and to do that they've been told to use a copy of the information rather than changing the live data. I was hoping it'd be as simple as creating a copy of the database, and linking them to that one (even if it was on the same server i suppose) but it may not be quite that simple i guess?

[vikpaw]

Much safer and better to setup a full blown test install. Plus you can use it to test your backups work and for playing around with new releases. It's even more flexible if it's a virtual setup.