I am trying to create a copy of a database for testing, I have moved some code out of a desktop application and onto the web and want to run the same process on each database, so I backed up the database and restored it to a new database, but it doesn't seem to restore the users of the first database with the same permissions in the second.
Basically I want two identical databases and run the same process on each - one from the web, the other from the desktop, and check the database results are the same.
I did do some searches on copying users over from one database to another and it just looked like it wasn't possible to automate it - you just have to do it all by hand, is that the case or is there some way to get it working.
The two databases are on the same server.
This should be MS SQL Server 2008 and later