We are migrating a few tables' data from one application to another application. These two applications are totally different tables and schema.
We have created general T-sql scripts and temporary tables to store the required data to transform the data in an acceptable format of destination application tables.
Checking here, is there any different approach that we can adapt to migrate the data between the different applications?
Thanks in advance, Venkat