Migration to work out of Source Files

Apr 2, 2014 at 9:32 AM
As far as I know, this migration wizard works out of a database. Is there a possibility that this will work with the source code as the basis for migration ? This is required as the sources will need to be in sync with the migration changes. Please let me know on this.
Apr 3, 2014 at 12:41 AM

I believe that the answer is no. I don't specifically parse C#, VB, Java ... looking for compatibility issues. But that said, what you can do is run SQL Profiler against your database and then run your application through a series of test that will exercise most (if not all) of your database. You can then save the SQL Profiler log to a file and then have SQLAzureMW analyze the SQL Profiler trace file. That will at least tell you if your dynamic SQL is ok. I know it is not 100% solution, but at least it might get you part of the way.