During my days as a software developer, I have worked with large datasets while developing applications. Sometimes the datasets got so big it was impossible to store them on existing drives. Now imagine moving a sizeable chunk of these huge datasets between different environments like development, testing and finally production. Needless to say, till I was introduced to the concept of ‘generation of insert scripts‘, it was not an easy task to migrate data.
The DBA who saved the day
During the time I mention above, a senior DBA told me how to generate insert scripts. Suddenly the process of data migration became a formality. It became easy and I used those insertion scripts every chance I got.
However, I forgot how that script was generated till now. Recently I came across an article where such generation techniques are discussed. The article can be found at sqlservercentral.com and I hope it helps someone.
I know I ll be using it a lot for data migrations whenever and whereever.
