April 23, 2012 at 8:13 pm
I am using database projects currently to maintain and version databases. So far it works well.
However, I would like to be able to dynamically configure deployed instances of the database to experiment with things like partitioning.
Is there a way to take an existing database project and have it deploy it such I can specify n filegroups, tell is where to put the log files and the data files etc.
I know that you can specify these things in the project, but I was wondering if there was a way to do this via an api. Perhaps using a Powershell script?
I am also looking at Data Tier applications but we don't have any immediate plans to push to Azure so I don't think it will be worthwhile.
Any ideas would be appreciated!
April 24, 2012 at 12:33 am
SMO has various methods you can exploit to do a whole range of database interaction tasks through C# and VB.net
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2012 at 8:04 am
That's true and I've considered using SMO with wither C# or PS. I was hoping there was some kind of feature I could leverage with a database project. Maybe that's not do-able.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply