We have a requirement where we want to bring data present in SQL Server to AWS - SQL Server (i.e. AWS RDS).
At present the data is present in on-prem SQL Server and on 1st of every month, the data is then transferred from SQL server to excel sheet. The excel sheet contains 7 different tabs. Those tabs are then imported into AWS- SQL Server. Both the database are present on different server and different environment and the excel tabs are created manually by running stored procedure in the SQL Server (on-Prem)
Hence currently the process looks like:
SQL Server (ON PREM) ---> Excel tabs --> SQL Server (AWS)
My requirement is to transfer data from SQL Server (on prem) to SQL Server (AWS) so that we can eliminate Excel sheet step in between.
Can someone please suggest me how to automatically transfer the data?
