I have two different databases on two different servers I compared the source database with destination database, there are few things like a Foreign key doesn't exist in the target database, a couple of columns are missing. Now after finding it, I want to update the schema from Source database to Destination database without losing the data on the target database.
When I ran it, it is giving me error and saying Target database may loose data, can anybody please help me or point me, how can I achieve this?
Any suggestion, link or code snippet can be very helpful. Thanks in advance.
"There is already enough hatred in the world lets spread love, compassion and affection."