Migrating SQL Server tables data from one application to another totally different application tables 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
For a one-off migration that's a good way. For continuing movement of data from a source to destination system e.g. OLTP system to a data warehouse, a proper ETL tool (SSIS/ BIML) would be better.