Hi
I am part of a team using Visual Studio/Team Foundation Server to manage database development.
We are using a database project to manage schema changes.
We have a folder in TFS, not in the database project where we keep run-once-only scripts to update metadata/config data. We see no reason in keeping these in the Pre/PostDeployment script area of the database project as these files will not be updated once they have been run.
My question is: is there a way to refer to files in a TFs folder, so that I can create a single deployment script with something like:
:r "$/MyProject/MetaDataScripts/Release1/Script1.sql"
:r "$/MyProject/MetaDataScripts/Release1/Script2.sql"
where the path is refering the source location in TFS Source Control Explorer?
Thanks
http://msdn.microsoft.com/en-us/library/ms170572(v=SQL.100).aspx