MS SQL 2005 - merge new rows and tables
-
I have a development database and production database. The developers have added new tables and new rows to existing tables. I need to merge these changes from the dev db to the prod db and am unable to construct a search to find an appropriate article. Can someone help point me in the right direction?
-
I have a development database and production database. The developers have added new tables and new rows to existing tables. I need to merge these changes from the dev db to the prod db and am unable to construct a search to find an appropriate article. Can someone help point me in the right direction?
Hey, these is a common thing when there are changes in the database schema. In such a case, your developer must have documented the changes that they have made. Create Alter scripts on the table with the changes on the schema and run the same on the Production environment to update the schema on the production. But ensure you backup the production database before executing the alter scripts.
-
I have a development database and production database. The developers have added new tables and new rows to existing tables. I need to merge these changes from the dev db to the prod db and am unable to construct a search to find an appropriate article. Can someone help point me in the right direction?
You need to look at the Red-Gate products. While you can create the scripts yourself it is tedious and time consuming. I have been using SQL Compare for years and would not be without it. Seriously it will totally eliminate this headache.
Never underestimate the power of human stupidity RAH