SQL Server Performance Forum – Threads Archive
Database Version Control
Is there native support in SQL Server 2000 or 2005?Are there market tools? Thanks for help
Not in SQL server 2000 I am using obejcst scripting and store them in Visual Source Safe there is a tool calle dbmeastrohttp://www.extreme.co.il/ —————————————-
Cast your vote
http://www.geocities.com/dineshasanka/sqlserver05.html http://spaces.msn.com/members/dineshasanka
SQL Server 2000 has no native support for version control, although if all you want is to maintain versions of database creation scripts, you could configure Visual SourceSafe to work with *.sql files, I think (not very sure) that SQL Server 2005 has some Visual SourceSafe integration in the management IDE. Nevertheless, check out:
-(Free) DDL Archive utility at http://www.sqlservercentral.com/products/bwunder/archiveutility/]
-RedGate Software at http://www.red-gate.com/solutions/sql/database_version_control.htm]
-SQLSourceSafe v2.2 at http://www.sharewareriver.com/product.php?id=6964]
-DBMaestro at http://www.extreme.co.il/products/dbMaestroOverview.aspx]
Nathan H. Omukwenyi
Is this possible that there is no native support for database versioning in 2005?
What about 2005 Team Foundation? New VSS? I can’t believe it! It just can not be true!!!
For such version controlling you must depend on the other tools like VSS as specified, but on the SQL SErver side of it there is no option available. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
What DB Version Control methodologies are you folks using
when a number of developers are working on a DB.
It seems tricky to script every DB object and then
after check-out and check-in — to run script recreating
these say tables (and all their dependencies and
REFILLING them with data.
Yes it is tricky. but you don’t have script them pne by one. from the EM you can create scripting for all objects —————————————-
Cast your vote
http://www.geocities.com/dineshasanka/sqlserver05.html http://spaces.msn.com/members/dineshasanka
We use PVCS at our end for version control and you can take help of VSS too, or check under TOOLS section of this website for any good tools, I’m sure they will be. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
I use a tool called ApexSQLEdit that’s basically Query Analyzer on steroids. Has a bunch of cool features, won’t get into all of them, but it integrates with VSS and SCC compliant version control systems. It’s the only product I’ve seen that comes close to keeping the db in sync with the repository and vice versa.
]]>