Hello, I am planning a cross-platform data migration from a C# database to SQL Server/MySQL (and some additional migrations from some proprietary databases). In the past, I have performed other migrations by creating two seperate sql scripts to.... A) export the source data to a flat file, and then... B) imported the data from the flat file while converting any asynchronous datatypes using CAST statements. This process was kicked off by a cron job to refresh the data monthly. Is this the most efficient method or do you have suggestions on how to simplify the process? Thanks!
I guess it really depends on the sources, but in general I've used SSIS to migrate data around. Especially when the migrations require restructuring, modification, conditional work, SSIS works much better than trying to do everything through TSQL native.