How to Copy Transactions From Database to Database via SSMS

select t.transactionid + 1000000 as fixedtransid, tl.*
from transactions t join translines tl on t.transactionid = tl.transactionid
where t.remotetransid = 0 and datetimetrans between '2023-03-23 23:32:15.000' and '2023-03-29 00:47:57.000'
and t.venueid = 1

 

select t.transactionid + 1000000 as fixedtransid, tp.*
from transactions t join transpayments tp on t.transactionid = tp.transactionid
where t.remotetransid = 0 and datetimetrans between '2023-03-23 23:32:15.000' and '2023-03-29 00:47:57.000'
and t.venueid = 1

 

select t.transactionid + 1000000 as fixedtransid, tc.*
from transactions t join transcards tc on t.transactionid = tc.transactionid
where t.remotetransid = 0 and datetimetrans between '2023-03-23 23:32:15.000' and '2023-03-29 00:47:57.000'
and t.venueid = 1

 

select t.transactionid + 1000000 as fixedtransid, t.*
from transactions t
where t.remotetransid = 0 and datetimetrans between '2023-03-23 23:32:15.000' and '2023-03-29 00:47:57.000'
and t.venueid = 1