I need to script off the contents of two configuration tables i have created in sql 2008 for when i deploy a project to live.
There are only around 20 or so lines in each, so I could spend 30mins writing a population script, but wondered if anyone knew of any 3rd party tools that would generate it for me?
The reason being that I can foresee this table growing a fair bit and it will be come quite difficult to maintain.. and also i'm sure there are other situations where i will need to do this in future :D
Question
BGM
Hi,
I need to script off the contents of two configuration tables i have created in sql 2008 for when i deploy a project to live.
There are only around 20 or so lines in each, so I could spend 30mins writing a population script, but wondered if anyone knew of any 3rd party tools that would generate it for me?
The reason being that I can foresee this table growing a fair bit and it will be come quite difficult to maintain.. and also i'm sure there are other situations where i will need to do this in future :D
cheers! :)
Link to comment
Share on other sites
5 answers to this question
Recommended Posts