Your strategy for loading a freshly built database with data will depend on how much you need. If just a few rows, then single-row INSERT statements will be fine, but for more than that, you'll need to build insert the rows using native-format BCP. Fortunately, SQL Change Automation (SCA) can be used with either strategy, as Phil Factor demonstrates.
When you build a database from scripts using SCA and need to get data into the target database, you can choose one of two strategies.
from DZone.com Feed http://bit.ly/2WR3g22
No comments:
Post a Comment