Editing DataBaseServerMigration



Verify no users are on server to be transfered (remote desktop > task manager > Users).

connect to 176 file explorer (new server) d drive > Data > (Example_Client) > delete

connect to 176 file explorer (new server) L drive > Logs > (Example_Client) > delete *only works if desired database is offline*

175(from server) take client database offline. click check box take clients offline.

Copy d drive > Data > (Example_Client) from 175 to 176 File explorer

Copy L drive > logs > (Example_Client) from 175 to 176 File explorer

Go to 176 (to server) bring database online (right click database in SQL > Tasks > Bring Online)

Run this query on server just brought online ------->

OPEN MASTER KEY DECRYPTION BY PASSWORD = 'asdfj;2l438as7dfj2;l3jk@#^@-81234-7sadj@FR@adswf^2%7yhadf'
ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY

EXEC sp_change_users_login 'Auto_Fix', 'oauser', NULL, 'admin' 
OPEN MASTER KEY DECRYPTION BY PASSWORD = 'asdfj;2l438as7dfj2;l3jk@#^@-81234-7sadj@FR@adswf^2%7yhadf'
OPEN SYMMETRIC KEY Card_Key_01
   DECRYPTION BY CERTIFICATE cardEncrypt;
GO

SELECT 'Unencrypted: ', SSN, 'Decrypted: ',  CONVERT(varchar(20), DecryptByKey(EncryptedSSN)), 'Encrypted: ', EncryptedSSN
    FROM Distributor
GO
<-------------

Go to bottom of databases (176) > security > logins > SQLS03\Reports > User mapping (left side)>  click check, newly added client database and ok

DONE WITH 175 AND 176. Go to Example_Client(remote desktop)

Go to file explorer on Example_Client(remote desktop) C:\Windows\System32\drivers\etc > open HOSTS file with notepad ++ > change ip at bottom from 175 to 176 and save (may need to be in admin mode)

Change ODBC 64 bit and ODBC 32 bit. Click icon > System DSN > double click 64bit (for 64) or 32 bit (for 32). login with admin password. Verify correct client pre populates. test connection. ok. finish.

Verify connection strings on 5 files C:\Program Files (x86)\Prodigix 
(
	prodigixsoftware.Ini
	OAParms.Ini
	connection.Ini
	prodigix.config
	CommissionCenter.exe.config
)
 change any ip .175 to "PDXSQLDATA"
 
 Update Report Center.  From the clients remote desktop go to C:\inetpub\wwwroot\ReportCenter40, copy ReportCenter40, CTL A delete everything from original. from regular computor, open file explorer and connect to 134v$ and client remote desktop.
 copy reportcenter40 from 134 to client server. Go to ReportCenter40\web.config, change dev_prodigix to Example.Client_Live and .175 to PDXSQLDATA
 
 If the report center doesn't work during your testing, check line 92 or //list reporting services report// of site.master.cs  in C:\inetpub\wwwroot\ReportCenter40. change given line 90ish-92 to  --> NetworkCredential cred = new NetworkCredential("reports", "!Prodigix1");
may need iisreset in terminal as admin

if they have the dc 6.0 modify c> inetpub> wwwroot > distributorcenter60 > includes > config_database.asp change .175 to PDXSQLDATA
dc50 > includes > constants.asp line 148 switch to PDXSQLDATA. Update constants.settings.asp line 10 to  client name and .176

test rc/sc/dc/signup/upgrade/Commissions in OA

134 vscource code web > dc50 > includes > constants.asp line 186 187 DONE