Re: Any relational database design tool written in Python

metaperl> I am hoping for something that can create database deltas.

What is a database delta? I know about SELECT, CREATE, INSERT, UPDATE,
joins, normalization, etc, but have never heard this term before.

There are two types of database deltas that I know of: metadata deltas (changes to the structure of the database such as altering columns in tables, adding/removing tables, altering views/SPs, changing access-controls, etc) and data deltas (differences in data when the structures are the same).

A metadata some sort of "diff" between two copies of a database (say, your "production" and "development" databases), allowing you to bring your production database up to the point where your development database is. A data-diff would be about the same as an incremental backup, allowing you copy new data from one database to another database with stale/older data on it.

I've written a couple simple database diffing scripts to synch production database to look like the development database snapshot. None were complete scripts to synch everything, but just handled what I needed at the time (usually just altered or added tables/queries).

-tkc




.

Relevant Pages

  • sp_help taking 20 seconds?
    ... My program accesses a Development database when I am developing, ... and a Production database when in actual use. ... So can this ever be normal, even on a heavily stressed server? ...
    (comp.databases.sybase)
  • Re: schema help
    ... only records the history as a sequence of deltas but is ... assume that the initial database state S0 is the empty ... In that sense the State-DB is just a read only view and only the ... History-DB is regarded as the primary source of the data to which ...
    (comp.databases.theory)
  • Re: ASP.NET/Crystal Reports Logon Failed
    ... I am using Crystal Reports 10 and Delphi ... My development database is different than my production database. ...
    (microsoft.public.dotnet.framework.aspnet)
  • How to get a Sybase database report utilization?
    ... The query works very well on my Production database. ... This query does not work on my development database and even ...
    (comp.databases.sybase)
  • Re: Probably impossible but....
    ... course) a client dataset mirroring your database and use deltas to ... taken you a long time to get to the offending code so it would be good to be ...
    (borland.public.delphi.non-technical)