Information and Links
Join the fray by commenting, tracking what others have to say, or linking to it from your blog.
- Information
- 10/3/2003
- Feeds and Links
- Del.icio.us
- Digg
- Technorati
- Tags
- No Tags Applied
- Related Posts
Posted on October 3rd
When you are creating a SQL script to deploy your system, Enterprise Manager does a good job with all of the schema (creating the tables, views, etc...) but doesn't handle creating INSERTS for any of your lookup tables. I used to generate SQL INSERT statements for my data using a SELECT (SELECT 'INSERT ..."' + [Col1] +'"...), but looking around on the web tonight, I found a cool stored proc that does all the work for you.
http://vyaskn.tripod.com/code.htm#inserts
I actually found quite a few utilities to accomplish this same result, but this was the first one I tried and it worked great!