Author Topic: Database change scripts  (Read 5943 times)

0 Members and 1 Guest are viewing this topic.

Offline sloe

  • Member
  • *
  • Posts: 1
    • View Profile
Database change scripts
« on: May 08, 2010, 10:24:04 pm »
Hi,

I created a view on the movies table. Since then the update procedure has problems updating the database structure. I guess because some system tables are locked.

Would it be possible to also deliver sql scripts with the changes? This would be pretty handy for me.

Greetings
sloe

Offline nostra

  • Administrator
  • *****
  • Posts: 2852
    • View Profile
    • Personal Video Database
Re: Database change scripts
« Reply #1 on: May 10, 2010, 01:39:14 pm »
Most apps that work with Firebird database have also the possibility to show the database structure and sql needed to produce tables, procedures etc.

Quote
Would it be possible to also deliver sql scripts with the changes? This would be pretty handy for me.

I do not want to do this as:
1. It is too advanced information for most of the users
2. I would need to keep this info up to date (more work)
3. People could try this stuff out and break the database
Gentlemen, you can’t fight in here! This is the War Room!

 

anything