Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question
SQL 2000 is officially unsupported by Microsoft. Its time for an upgrade. – Kin Jan 7 '14 at 12:56
You can build scripts that do this, but the number of edge cases - and the complexity it will require, especially since SQL Server 2000 lacked a lot of the modern DDL commands - will make it a very tedious approach. Why not trial/buy a tool that someone has already spent countless hours writing and worked out all those bugs for you? For example, you can do exactly what you need with the standard edition of Red-Gate's SQL Compare within minutes. Also see this post about re-inventing the wheel. – Aaron Bertrand Jan 7 '14 at 14:23
Thanks Aaron, looks promising and will look into it, anything that saves me time would be excellent. Many thanks. – John Cogan Jan 8 '14 at 13:47
Agreed Ken but then I also stated to the client that .NET and SQL 2008 R2 (at the minimum) would be a better choice but they had these servers sitting doing nothing and insisted on using them for the Intranet site. – John Cogan Jan 8 '14 at 13:49

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.