Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mfahner
Starting Member
11 Posts |
 Posted - 2006-12-19 : 15:35:40
|
| Hello,I have been given a task to automate our mssql database builds via scripts. However I am not sure which technologies I should use. I have read that you can do this sort of this with SQL-DMO but that looks like its dying according to MSDN, TSQL with batch scripts. Basically right know we have scripts that we run and that print out the results to the result pane and then we save the results as a sql file.This is how we create our database, triggers, views and stored procedures. Any idea on how to automate this would be greatly appreciated. A |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-12-19 : 15:53:38
|
| There are a few packages around that will help you do this. Check out Redgate software for one, as I'm pretty sure they do it. At my work we're using a custom app that uses VSS and an Excel data dictionary to create the database build scripts on the fly and it works quite well for us. HTH,Tim |
 |
|
|
mfahner
Starting Member
11 Posts |
Posted - 2006-12-19 : 16:01:12
|
| Timmy,I am currently evaluating Red-Gate SQL Packager but it seems to have a couple limitations like only a primary file group is allowed. What did you write your custom app in? |
|
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-12-19 : 18:07:57
|
| It's in C# but has some VBA components to interface with the Excel documents we use. |
|
|
|
Kristen
Test
22859 Posts |
|
|
|
|
|
Scripting Database Builds