Search Forum
(57415 Postings)
Search Site/Articles

Archived Articles
712 Articles

C# Books
C# Consultants
What Is C#?
Download Compiler
Code Archive
Archived Articles
Advertise
Contribute
C# Jobs
Beginners Tutorial
C# Contractors
C# Consulting
Links
C# Manual
Contact Us
Legal

GoDiagram for .NET from Northwoods Software www.nwoods.com


              
Printable Version

SQLDMO For C# Enhanced
By Joe Sytniak

I often need to compare versions of databases and comparing scripts is one way to find differences in the schemas. I had been using a two step process of using the scptxfr utility to generate scripts, then using a file comparison utility such as Beyond Compare to compare the generated script files. One problem with the scptxfr utility is that is often generates the objects in what appears to be a random order. This makes my file comparison step very ineffective as there are so many false positives reported as differences. I needed a way to control the order that the scripted objects appear in the script files. I was considering writing an app using SQLDMO to generate the scripts. So I took a look on the net and decided this app would be a good starting point. I tweaked the interface a bit and added the scripting features.

Download Source