I've discovered that in Visual Studio 2010 Professional it is possible to refresh the database for a SQL Server Database Project (This feature is normally only available to the Premium and Ultimate versions). All you need to do is delete all the SQL files from the "Schema Objects" folder (but leave the folder structure intact) and the "Database.sqlpermissions" file. Then the "Import Database Objects and Settings..." option will become enabled, allowing you to refresh the database project with the latest schema.
I would like to write a macro for Visual Studio 2010 that can do this.
The macro should...
Any tips on writing macros in Visual Studio will help me. Thanks.
information on writing visual studio macros is located here...
http://msdn.microsoft.com/en-us/library/b4c73967(v=vs.80).aspx