Jump to content

Check out our Community Blogs

Register and join over 40,000 other developers!

Recent Status Updates

View All Updates

- - - - -

How to push out ms sql database structure changes in delphi?


  • Please log in to reply
1 reply to this topic

#1 kidjake28


    CC Lurker

  • Just Joined
  • Pip
  • 1 posts

Posted 15 February 2012 - 01:15 PM

I'm looking for some consulting info.

I have a delphi program that I've written and now and then I make changes to the ms sql database structure. I would like to know what is the easiest way to push out the dbase structure changes automatically to the install base that i have?

I can generate scripts within MS SQL Management studio but not sure how to take it from there.
  • 0

#2 WingedPanther73


    A spammer's worst nightmare

  • Moderator
  • 17757 posts
  • Location:Upstate, South Carolina
  • Programming Language:C, C++, PL/SQL, Delphi/Object Pascal, Pascal, Transact-SQL, Others
  • Learning:Java, C#, PHP, JavaScript, Lisp, Fortran, Haskell, Others

Posted 15 February 2012 - 02:28 PM

We usually create a small application to do that. You could also have your application store an internal DB version number, and look for that in the DB structure. When there's a mismatch, it could call a function to perform the update automatically.
  • 0

Programming is a branch of mathematics.
My CodeCall Blog | My Personal Blog

My MineCraft server site: http://banishedwings.enjin.com/

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download