So, is there no way i can version the stored procedures or tables.Has anyone done anything similar.Does any system table have a description or any field i could store the version for the tables/stored procedures/views.
thanks jim, but i think, If its just 20% tables changing and that two in a
On Mon, Dec 19, 2005 at 08:35:14AM -0800, vishal saberwal wrote:
So, is there no way i can version the stored procedures or tables.
Has anyone done anything similar.
Does any system table have a description or any field i could store the
version for the tables/stored procedures/views.
No,
hi all,
We installed a first version (1.0.0.1) of our schema. then came a few
patches we had for a few stored procedures and tables (1.0.0.2). Then
even more (1.0.0.3) (1.0.0.4). Some chose to upgrade to version 1.0.0.3
and stick to it, while some others chose to upgrade to 1.0.0.4.
Now when i
The way I handle this is to version the entire schema and have scripts
that know how to upgrade from one version to another. If you think about
it, you really want/need everything in the database to be designed to
run together anyway. I've yet to find a case where I'd want some of the
stuff in the