Hi,
I have 2 databases, one called X (development db) and the other is Y (production db). I work with db X (development db), and I alter table A, create a new table B, create a new stored procedure C. After I am done my works with db X, now in db Y, I want to do the same things as I do in db X (assume I already have old version table A in db Y but not table B, new sp C, so can you tell me what is the fastest and most convenient way to make same changes/ new creating for db Y?
Any idea? Thanks in advance