During web-site development, I am using VStudio 2005 with SQL-Express.

I frequently publish changes in table structure to another server that is running SQL- Server 2000 standard edition.
Is there a simple way to replicate changes in database tables design without copying the whole mdf-file and loosing the existing data in the target database?

I am not sure if Aspnet_regsql would suit my needs!
I already have cofigured my database for user/membership etc... plus added my own tables. So it is a fully functional Aspnet-mdb!
I need to find an easy way to publish changes to my tables made on the development machine to another server - best without copying 20+ MB over the network and loosing data on the target server!

 What I would be looking for would be a Wizard or Add-In that generates "ALTER ... " sql-statements which I could run on the target

So far neither "database publishing wizard" nor "SQL Server Management Studio Express" could do this .... or I was too dumb to find out how :)

thanks, Reinhard

Quest Software makes a comparison tool that allows you to compare 2 databases and will generate scripts to make one match the other.  I assume there are other 3rd party tools, but I haven't tried any others.  I don't know of any way to do it other than 3rd party software (or by building something yourself).