Synchronize Database Structure

Posted At : August 24, 2006 12:35 PM | Posted By : Steve
Related Categories: DataMgr

When you take development code live, you need to make sure that the production database has all of the tables and columns it needs.
Fortunately, you can define the table structure that you need in a component (or elsewhere) and DataMgr (if you've read my blog before, you saw that coming) can make sure that the required tables and column exist in the database.
The same approach can be used for to self-install tables for an application (I used this on CodeCop).
Watch the presentation.
View other DataMgr presentations.
If you use SQL Server and you aren't interested in DataMgr or you need to synchronize more than tables and column, Red Gate's SQL Compare looks to be a very good tool (I have personally heard it highly recommended by two different users this week).
UPDATE
I just saw someone mention that they used AdeptSQL Diff for this purpose as well. So you might investigate that in addition to SQL Compare.

Comments (2) | Print | del.icio.us | Digg It! | Linking Blogs | 2524 Views
Comments (Comment Moderation is enabled. Your comment will not appear until approved.)
[Add Comment]
Database is itself a very important and useful thing!!! It helps me greatly every time !!! :)
# Posted By massyandra | 9/18/06 2:46 PM
I just thought I'd throw in my vote for the best database compare tools. I have tried both Red Gate and Adept, but in my opinion SQLDelta wins (http://www.sqldelta.com/).
# Posted By Kenton | 9/25/06 4:12 PM
[Add Comment]
BlogCFC was created by Raymond Camden. This blog is running version 5.8.001.