Beginner's Guide to SQL Server Database Development with VSTS Database Edition
Results of a Schema compare appear in Figure 9. I've applied a filter option so you can see the results more easily and compare them to the changes you made above.
Figure 9: Schema compare results
Included in the list of changes are database users and other items. Mostly likely, you will want to exclude users, especially if you're syncing with your development server. To exclude, you need to change the Update Action to "Skip". Right-clicking at the category level allows you to select "Skip All". This action is illustrated in Figure 10.
Figure 10: Opting to skip all
Changes are applied in a set of DDL statements. You can view the DDL and access other options from a toolbar like the one in Figure 11.
Figure 11: Toolbar options
The "Write Updates" button on the toolbar will synchronize the source with the Target. I would recommend reviewing the ScriptsIgnoredOnImport.SQL file after synchronizing.
For Further Study
I've covered the basic development tools and features. There are some other useful features.
Data Compare allows a developer to synchronize the data between two databases. Instead of creating DDL statements, it creates DML statements.
Applications may require multiple databases. In fact, databases may even do cross database queries. Reference Variables allow one project to reference another project as if the project were doing a cross database query.
There are also unit testing tools. I'll cover this subject in another article.
Finally, advanced topics are included in the Sources at the end of the article. This article was meant to get you running faster with the tool. "Introducing Visual Studio 2005 Team Edition for Database Professionals" is a much broader introduction.
Transact SQL development requires a specialized development tool. Visual Studio Database Edition is a capable TSQL development platform. VSTS database edition not only manages all of your database artifacts, it also enables various database synchronization scenarios.
- "Introducing Visual Studio 2005 Team Edition for Database Professionals": http://msdn.microsoft.com/en-us/magazine/cc163472.aspx
- "Data Dude Blog" what has changed in Database Edition 2008: http://blogs.msdn.com/gertd/archive/2007/11/21/visual-studio-team-system- 2008-database-edition.aspx
- Database Edition Power Tools: http://www.microsoft.com/downloads/details.aspx?FamilyID=73BA5038- 8E37-4C8E-812B-DB14EDE2C354&displaylang=en
About the Author
Jeffrey Juday is a software developer specializing in enterprise application integration solutions utilizing BizTalk, SharePoint, WCF, WF, and SQL Server. Jeff has been developing software with Microsoft tools for more than 15 years in a variety of industries including: military, manufacturing, financial services, management consulting, and computer security.
Jeff is a Microsoft BizTalk MVP. Jeff spends his spare time with his wife Sherrill and daughter Alexandra. You can reach Jeff at firstname.lastname@example.org.
Page 4 of 4