User Story 1155290

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 -- QA Query DECLARE @return_value int EXEC @return_value=[BANKDB_P].[spGetSalesList] @AcctNo='L571', @TrustKey=118587673 , @BegYr=N'2016-01-01 00:00:00', @EndYr=N'2016-12-31 00:00:00', @Suppress=1, @Deleted=0, @DIK=0 -- SAT query DECLARE @return_value int EXEC @return_value=[BANKDB_P].[spGetSalesList] @AcctNo='L571', @TrustKey=118587673 , @BegYr=N'2016-01-01 00:00:00', @EndYr=N'2016-12-31 00:00:00', @Suppress=1, @Deleted=0, @DIK=0
Compare?
Match