How to version control in SQL 2000?

[kackson]

Hi.
I would like to version control my data in SQL 2000. Currently I've
stored the data/time info of my data whenever I add or edit the table.
Are there such built in support in SQL 2000? If not, anyone care to
share some tips and tricks to perform version control with SQL 2000?
Thank you.

[filesiteguy]

Re: How to version control in SQL 2000?

kackson scratched out in the sand
[color=blue]
> Hi.
> I would like to version control my data in SQL 2000. Currently I've
> stored the data/time info of my data whenever I add or edit the table.
> Are there such built in support in SQL 2000? If not, anyone care to
> share some tips and tricks to perform version control with SQL 2000?
> Thank you.[/color]

I'd say use a VC system such as CVS or subversion and store your exported
schema there.


--
kai - kai at 3gproductions dot com
www.gamephreakz.com || www.filesite.org
"friends don't let friends use windows xp"

[Erland Sommarskog]

Re: How to version control in SQL 2000?

kackson (kackson@yahoo. com) writes:[color=blue]
> I would like to version control my data in SQL 2000. Currently I've
> stored the data/time info of my data whenever I add or edit the table.
> Are there such built in support in SQL 2000? If not, anyone care to
> share some tips and tricks to perform version control with SQL 2000?[/color]

No, there is no built-in support, and you better come up with a
requirement specification of what you really want, because this may be a
tall order. It's certainly nothing you do for fun.

I really don't want to say more until I know more about your system.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp