Included page: .FrontPage.QA.Archive.SqlServerMigration.SetUp (edit)
| import |
| TBOT.Generic.Database |
| ddt: SetUp | |
| key | value |
| ConnectionString | Server=10.203.25.13,1601;database=BTMCLIENTDB;User Id=akjain; password=akjain1 |
Overriding QA and SAT Connections
| ddt: SetUp | |
| key | value |
| ConnectionString | Server=10.203.25.13,1601;database=BANKDB02;User Id=akjain; password=akjain1 |
| RightConnection | Server=10.203.25.23,1605;database=BANKDB02;User Id=akjain; password=akjain1 |
| ddt: CompareRecordSets | -- OLD Query Select p.AcctNo, Mode, DB_Name, Server, a.StopSvc_Dt from BTMDB..Package p, BTMACCTDB..AcctInfo a where SuperID <> 0 And p.Mode='PRD' And p.AcctNo *= a.AcctNo And p.AcctNo not like '$%' And p.AcctNo not like '@%' Order by p.AcctNo | -- NEW query Select p.AcctNo, Mode, DB_Name, Server, a.StopSvc_Dt from BTMDB..Package p LEFT outer JOIN BTMACCTDB..AcctInfo a on p.AcctNo = a.AcctNo where SuperID <> 0 And p.Mode='PRD' And p.AcctNo not like '$%' And p.AcctNo not like '@%' Order by p.AcctNo |
| Compare? | ||
| Match | ||
Keyboard Shortcuts ?
General
- t Test page or suite
- e Edit page
- v View page (after test)
- a Add new page
Go To
- g u User Guide
- g q Quick Reference Guide
- g f Full Reference Guide
- g c Recent Changes
Edit Mode
- CTRL+s Save page
- ESC Cancel edit
Tools
- p Properties
- w Where used?
- AK+v Versions
- AK+h Page History
- / Focus on search bar
- s Open search page