There is a new Visual Studio Team "member" coming out in the autumn, called Team DB Pro. I have only tried to compare database structures between my Development DB and Production DB. It is nice that it is part of the VS family so you get everything in the environment you are used to.
I immediately missed some features though, some of which other companies, e g Toad and Red-gate, have in their products:
- It should be optional to find differences from white space and extra line feeds irrelevant to DB behaviour. If found 325 differences out of 350 and there is perhaps 5 real differences, which I'd like to find.
- Intellisense on databases, tables, columns, SPs, data-types etc.
- It should be possible to transfer(sync) differences in both directions, not only left-to-right
- Possiblity to ignore schema owner (dbo, users) when comparing tables and SPs, again to find real differences.
- Use SQL 2000 <-> SQL 2005. There are only some directions available so far. It should be possible to compare and transfer in all directions.
Downloads:
http://msdn.microsoft.com/vstudio/teamsystem/dbpro/
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=507742&SiteID=1
No comments:
Post a Comment