This program was written a decade ago when I had the task of converting 75 stored procedures over to TSQL. At the time, there weren't any such conversion programs. The only conversions I could find ...

When planning a database migration, the main goals of a database specialist or another person responsible for this task are: To reach the best performance and reliability of the target database To ...

#TODO: overhaul description here. #In short: use this script we can embedd multiple tables in each other this is much slower and has bigget memory footprint! than the master-flat script # Note: first ...

It's no secret that even though MySQL has been a Microsoft partner, it also is a Microsoft competitor. And ever since Oracle made overtures to buy Sun and (get MySQL in the process), Microsoft's been ...

I'm coding on a Win32 database client application. Previously the database worked great with MySQL. I'm trying to introduce it into my work environment. Work does not allow open source applications ...

皆さんは、異なるDB間でのデータコピーを行う際にどういう方法を使うでしょうか？ まるっと全部コピーするのであれば第127回 CLONEプラグインを導入しようで紹介したcloneプラグインを使ったり、レプリケーションを使ったりします。またバックアップを ...

As an addendum to last week's post about a recent SQL Server camp held for PHP developers, Microsoft's Brian Swan has published some new nuts-and-bolts details for converting MySQL queries. Swan, who ...