Take the 2-minute tour ×
Programmers Stack Exchange is a question and answer site for professional programmers interested in conceptual questions about software development. It's 100% free, no registration required.

So my company is using TFS and SQL to Manage their Database (MS SQL Server). It integrates with the nightly build servers to do builds and produce scripts to build the entire Database. Also the Compare Schema tool that visual studio offers is really handy.

We want to do the same with Oracle, Preferably with TFS if that's even possible. It can be done without, but is this a possibility?

Also are there any tools to assist in automatically creating the Database in a Nightly Build?

What about Managing Upgrades?

Our Big worry is moving triggers and the MS SQL Service Broker to Oracle... this we might have to do manually though.

share|improve this question
    
Sharing your research helps everyone. Tell us what you've tried and why it didn’t meet your needs. This demonstrates that you’ve taken the time to try to help yourself, it saves us from reiterating obvious answers, and most of all it helps you get a more specific and relevant answer. Also see How to Ask –  gnat Apr 19 '13 at 19:17
    
Well We've looked at Toad Extensions for Visual Studio, im more doing research for an "Idea meeting" basically. So nothing has been "tried" of yet. and I literally know zero about what's out there regarding this subject. –  Mercfh Apr 19 '13 at 20:30

1 Answer 1

up vote 1 down vote accepted

This has nothing to do with TFS - all TFS does is call MSBuild that (basically) runs visual studio in batch mode, so if you can get your DB project deploying to Oracle then TFS will be happy. (though you'll be much better off using Jenkins as it kicks TFS's bottom).

So, you have to get the VS project to deploy your DB project to an Oracle DB, now this should be possible - as you just have to specify a different connection string in the DB project settings (or the .dbdeployment file). Chances are you'll end up with SQLServer-specific sql generated and deployed, or VS will refuse to use anything other than a SQLClient connection.

So, go direct and get the Oracle Developer Tools for Visual Studio which will give you the same DB projects, and its own schema compare tool.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.