Alter table schema based on another table

In sql if i had 2 databases where each had similar columns but not exactly the same schema , is there a built in way to alter the schema of a table in database2 make it similar to the schema in of a table database1?

considering that the column type and column name and default value are the factors to decide if 2 columns match.

Answers


No, there is no built in functionality for doing this, you will either have to do it manually or use a comparison tool such as RedGate SQL Compare or Visual Studio.


Need Your Help

Not able to use resources inside .cs file

asp.net resources

I have project asp.net with namespace test and I'm using resources (files Resource.resx and Resource.en-GB.resx). I have in resources key MY_TEXT with value. In file .aspx I can use

xcode 5 file navigation for visual studio user

xcode visual-studio navigation

I've used Visual Studio for years and have just started work on a C++ project in XCode, and I'm finding some aspects of file navigation in XCode frustrating.