It may be useful to make a clone of the production ManagementStudio database into a development environment. It's important that the following SQL script is run against the restored database in the development environmnt before the dev instance of ManagementStudio is started:
-- Delete License Key
DELETE FROM [dbo].[zIntnl_Setting-Global] WHERE [Name] = 'License_CustomerId'
DELETE FROM [dbo].[zIntnl_Setting-Global] WHERE [Name] = 'License_Key'
-- Delete Send Email Server Name
DELETE FROM [dbo].[zIntnl_Setting-Global] WHERE [Name] = 'Email_Smtp_Server'
-- Delete Public Url (pointing to Prod)
DELETE FROM [dbo].[zIntnl_Setting-Global] WHERE [Name] = 'Public_Url'
-- Delete any Emails that are in the send queue
DELETE FROM [dbo].[Msg_EmailCentre] WHERE [IsSent] = 0
-- Delete any notifications emails users have subscribed to
DELETE FROM [dbo].[MyPrefs_SubscriptionEvent]
-- Turn off all Scheduled Tasks
UPDATE [dbo].[Registry_Schedule] SET [IsEnabled] = 0
-- Turn off all PowerShell Scripts
UPDATE [dbo].[Registry_Script] SET [IsEnabled] = 0
-- Disable Survey and Test Sign-Off Reminder Emails
UPDATE [dbo].[Survey-Config] SET [SendReminderEmailAfterXDays] = 0
Once the above has been completed, the following steps will need to be taken:
- Add a licence
- Add SMTP email server details (if required)
- Add the public URL
- Create test accounts (if required)