I built a internal web application for a client that manages applications to programmes for their employees.
The system is Classic ASP on a set of clustered and load balanced Windows 2000 Servers using MS SQL 2000 as their database.
All is fine and I've been asked to do some additions for Phase 2. The additions require changes the tables, some stored procedures and possibly the addition or change of some basic Insert triggers.
Now my question was:
If I make changes to the database is there anyway I can generate a script that will create ALTER statements for them to run against their live databases ? Reason I need this is because I do not have access to the internal live system for security reasons (I am contracted not within their IT department).
I work on my local development database using SQL Server Enterprise manager (2000) which runs within Oracles Virtual Box running Windows Server 2000 Advance (Version 5).
I will have to provide them with the modified web files and a set of scripts to alter the schema.
I have to assume that they will run the scripts using old software (Minimum circa 2000) but possibly will use newer versions.
Many thanks in advance. John