BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Upgrading databases on product upgrades          BorlandTalk.com Forum Index -> Delphi Thirdparty Tools (General) View previous topic :: View next topic   Author Message William Egge Guest Posted: Mon Sep 18, 2006 7:40 pm    Post subject: Upgrading databases on product upgrades I have a product which uses an SQL database, and the database can be pretty much any SQL database the user wishes to use. For instance SQL Server, Firebird, Pervasive, MS Access... When I add new features to the product, the database on the users end also needs to be updated. This is a lot of tedious work for me. I need some sort of tool to help me with upgrading databases. Any suggestions? -Bill Back to top Niels Guest Posted: Mon Sep 18, 2006 11:05 pm    Post subject: Re: Upgrading databases on product upgrades "William Egge" <begge (AT) eggcentric (DOT) com> schreef in bericht news:450eb016 (AT) newsgroups (DOT) borland.com Quote: I have a product which uses an SQL database, and the database can be pretty much any SQL database the user wishes to use. For instance SQL Server, Firebird, Pervasive, MS Access... When I add new features to the product, the database on the users end also needs to be updated. This is a lot of tedious work for me. I need some sort of tool to help me with upgrading databases. Any suggestions? I have created a tool like this in the past, to do exactly what you ask. At the moment it is not available at the moment but i can ask the sales team to make it available when you like. The only thing is, it is dutch for now. But with a little help i can translate it in englisch as well. The tool is a wizard that uses a sql-file to check the structure off the client database(s). You can tell the tool where to find the sql-file or the databases by runtime -parameter or by using a profile file (*.ini). When it find some diferences it makes first a copy from the database, after that it does create a backup and restores it again after that the patches of the database structure will be executed. The tool can also check the values of the generators when you like and can call a Stored procudere to do a late database check out or make chances insite the database content. When there are no errors found it renames the database to the old file name. So when you are intrested let me know. Niels Lumensof Int. The Netherlands Quote: -Bill Back to top Sean Cross Guest Posted: Tue Sep 19, 2006 2:23 am    Post subject: Re: Upgrading databases on product upgrades William Egge wrote: Quote: I have a product which uses an SQL database, and the database can be pretty much any SQL database the user wishes to use. For instance SQL Server, Firebird, Pervasive, MS Access... When I add new features to the product, the database on the users end also needs to be updated. This is a lot of tedious work for me. I need some sort of tool to help me with upgrading databases. Any suggestions? -Bill using multiple databases makes it a lot harder as there will be different sql for each database. The way I did it with SQL Server, was to have a view called versoin number ('Select 12 as Versionnumber'). Whenever I changed the db, I updated the version number. I then used SQL compare (http://www.red-gate.com/) to create an upgrade script. On running the program, I checked the version number. if it was wrong, i ran the appropriate upgrade script(s). with dbisam, I do it a different way. I have a datamodule with a table component for each db table. if the version number changes, I test each table and create any new fields/indexes in code. For really complicated changes, i also un upgrade scripts but that is rarely needed. Hope that helps. Regards Sean ----------------------------- Sean Cross Systems Development Catalyst Risk Management Back to top Ron L. Guest Posted: Tue Sep 19, 2006 6:59 am    Post subject: Re: Upgrading databases on product upgrades Context Software has a tool that allows you to "version control" your database schema and will automatically create a difference script between the versions - it supports MS SQL, DBIsam and other formats (I only use the 2 mentioned) - this could be an alternative to the SQL Compare product mentioned below (which I am sure does a fine job as well). Ron. http://www.bitogo.com/infopath/index.html "Sean Cross" <sean.cross (AT) crm (DOT) nospam.co.nz> wrote in message news:450f0e57$1 (AT) newsgroups (DOT) borland.com... Quote: William Egge wrote: I have a product which uses an SQL database, and the database can be pretty much any SQL database the user wishes to use. For instance SQL Server, Firebird, Pervasive, MS Access... When I add new features to the product, the database on the users end also needs to be updated. This is a lot of tedious work for me. I need some sort of tool to help me with upgrading databases. Any suggestions? -Bill using multiple databases makes it a lot harder as there will be different sql for each database. The way I did it with SQL Server, was to have a view called versoin number ('Select 12 as Versionnumber'). Whenever I changed the db, I updated the version number. I then used SQL compare (http://www.red-gate.com/) to create an upgrade script. On running the program, I checked the version number. if it was wrong, i ran the appropriate upgrade script(s). with dbisam, I do it a different way. I have a datamodule with a table component for each db table. if the version number changes, I test each table and create any new fields/indexes in code. For really complicated changes, i also un upgrade scripts but that is rarely needed. Hope that helps. Regards Sean ----------------------------- Sean Cross Systems Development Catalyst Risk Management Back to top Ed Dressel Guest Posted: Tue Sep 19, 2006 10:18 pm    Post subject: Re: Upgrading databases on product upgrades I have a table called VersionINfo that contains a list of changes that have been made to the database. I register all my update classes and checked if their ID's are in the database. -- Ed Dressel "William Egge" <begge (AT) eggcentric (DOT) com> wrote in message news:450eb016 (AT) newsgroups (DOT) borland.com... Quote: I have a product which uses an SQL database, and the database can be pretty much any SQL database the user wishes to use. For instance SQL Server, Firebird, Pervasive, MS Access... When I add new features to the product, the database on the users end also needs to be updated. This is a lot of tedious work for me. I need some sort of tool to help me with upgrading databases. Any suggestions? -Bill Back to top Woody (TMW) Guest Posted: Wed Sep 20, 2006 10:01 pm    Post subject: Re: Upgrading databases on product upgrades "Ed Dressel" <none> wrote in message news:4510266d$1 (AT) newsgroups (DOT) borland.com... Quote: I have a table called VersionINfo that contains a list of changes that have been made to the database. I register all my update classes and checked if their ID's are in the database. Ed, that's how I do things too. My table is called Versionator since that's what I named the program. I built a management part that I use to track all my projects and their DDL changes. It creates an update file that can be read and any updates will be done in the order they were entered. That way, it doesn't how far down the line any database is, they will be updated to current status. As for the OPs orginal question, since I wrote my own, I haven't searched for anything else like this so I don't know any to point you to. There are lots of posts about this though so some searching on google or mers may turn up some ideas for you. Woody (TMW) Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         BorlandTalk.com Forum Index -> Delphi Thirdparty Tools (General) All times are GMT Page 1 of 1   Jump to: Select a forum C++ Builder Newsgroups----------------C++ BuilderC++ Builder (ActiveX)C++ Builder (Announcements)C++ Builder (Command Line Tools)C++ Builder DatabasesC++ Builder Databases (ADO)C++ Builder Databases (Desktop)C++ Builder Databases (InterBase Express)C++ Builder Databases (Multi-Tier)C++ Builder Databases (SQL Servers)C++ Builder (Graphics)C++ Builder (IDE)C++ Builder (Internet)C++ Builder (Internet Socket)C++ Builder (Internet Web)C++ Builder (Jobs)C++ Builder (Language)C++ Builder (Language C++)C++ Builder (Compatibility with MFC)C++ Builder (Native API)C++ Builder (Non-Technical)C++ Builder (Students)C++ Builder (Third Party Tools)C++ Builder (Upgrade)C++ Builder (VCL)C++ Builder (VCL Components Usage)C++ Builder (VCL Components Development)C++ Builder (VCL Usage)C++ Builder (WinAPI)C++ Builder Installation Delphi Newsgroups----------------Delphi (General)Delphi ActiveX Controls UsageDelphi ActiveX Controls DevelopmentDelphi As400Delphi DatabasesDelphi Databases (ADO)Delphi Databases (dbExpress)Delphi Databases (Desktop)Delphi Databases (InterBase Express)Delphi Databases (Multi-Tier)Delphi Databases (SQL Servers)Delphi DeploymentDelphi GraphicsDelphi IDEDelphi InternationalizationDelphi InternetDelphi Internet Isapi-WebBrokerDelphi Internet WebSnapDelphi Internet WinsockDelphi JobsDelphi Language BASMDelphi Language ObjectPascalDelphi Model Driven Architecture (General)Delphi Model Driven Architecture (Third Party)Delphi MultimediaDelphi Native APIDelphi Non-TechnicalDelphi ObjectPascalDelphi OLE AutomationDelphi OO designDelphi OpenToolsAPIDelphi Reporting-ChartingDelphi RTLDelphi StudentsDelphi TeamSourceDelphi Thirdparty ToolsDelphi Thirdparty Tools (General)Delphi Thirdparty Tools (IntraWeb)Delphi Thirdparty Tools (RaveReports)Delphi UpgradeDelphi VCLDelphi VCL ComponentsDelphi VCL Components UsingDelphi VCL Components WritingDelphi WebServices SOAPDelphi WinAPIDelphi XMLDelphi Installationcomp.lang.pascal.delphi.components.misccomp.lang.pascal.delphi.components.usagecomp.lang.pascal.delphi.components.writingcomp.lang.pascal.delphi.databasescomp.lang.pascal.delphi.misccomp.sources.delphi JBuilder Newsgroups----------------JBuilderJBuilder AnnouncementsJBuilder Applet IssuesJBuilder As400JBuilder CompilerJBuilder CORBA/RMIJBuilder DatabasesJBuilder DB SwingJBuilder DebuggerJBuilder DeploymentJBuilder DocumentationJBuilder EnterpriseJBuilder HandheldJBuilder IDEJBuilder JavaJBuilder JavaAPIJBuilder Java LanguageJBuilder Java SwingJBuilder Java BeansJBuilder Java Beans UsageJBuilder Java Beans DevelopmentJBuilder JBCLJBuilder JDataStoreJBuilder JobsJBuilder LinuxJBuilder MacintoshJBuilder & MobileSetJBuilder MultiLingual AppsJBuilder Non-TechnicalJBuilder OpenToolsJBuilder Servlets (JSP)JBuilder StudentsJBuilder Team DevelopmentJBuilder Thirdparty ToolsJBuilder UpgradeJBuilder Installation InterBase Newsgroups----------------InterBaseInterBase Bug DiscussionInterBase GeneralInterBase IBConsoleInterBase OpenSourceInterBase ReplicationInterBase SQLInterBase ThirdpartyInterBase Installation Miscellaneous Borland Newsgroups----------------AppCenterAppServerEnteraVisiBroker  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.