db compare program

[webmast3r]

dear friends,

3 months ago i had a database that my software was working on... due to additional db upgrades, i needed to add fields to some tables..

today, i find myself in a stage where my program is almost complete, and i need to replace the old exe with the new one.

the problem is that i have many tables, and i dont remember what are the fields that i have added.

i need to create a script that compares the runnning database, and the new database, and makes the adjustments (which are only fields addition)

i know that dropping all fields and recreating them would save the problem, but that would lose the available data...

any suggestions on how i can do that?
i appreciate your help,

Cheers, dan

 

[hmckillop]

If you have a look at Red-gates SQL Compare, it will do everything you ask and more.

"I'm living so far beyond my income that we may almost be said to be living apart

 

[miq]

HI,
or you can BCP your data to a text file. Recteate new DB and import data to DB using BCP & Format file) or bulk insert or even through DTS.

B.R,
miq