Hi All
I'm using final builder as the continuous integration server for my project. I would like to do a schema compare (something similar to the schema compare feature in VS2010).
Currently I'm trying to use MSbuild and compare schema with that. But sometimes it fails. Also it won't allow comparing selective set of items (I need to compare only tables, sps but no the users etc...)Is there any particular way of achieving this more effectively?
Basically what I want to do is update the schema (tables, sps etc...) and ignore (users, logfiles ) etc... Please let me know about the ideas
Thanks
Ami
This is really outside the realm of what we do with FinalBuilder. I would suggest you look at some database tools vendors like Embarcadero or Red Gate.
Hi
I think you misunderstood me. We are using final builder server as the continious integration server.
Steps :
- Individual developers do the chnages on their local machines and database copies and then do a schema compare with the database project.
- We have setup FB server to detect vault trigger and run the tests when it detects a checkin.
- Before running the tests, we need to update the database connected to FB codebase so that we can run the tests.
- I'm facing some issues as I use MSBuild for schema compare.
Is there a better way of doing a schema compare or can you suggest an improvement on this?
Amila
I think I understood you fine. FinalBuilder doesn’t have any built in functionality to do schema compares itself, but it’s quite capable of running such a tool should you find one.