• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 368
  • Last Modified:

Read SQL Script using SQL-SMO

Hi
I'm developing a C# win app that is using SQL-SMO.  I know SMO has the functionality to generate SQL scripts, but does it have the ability to read/parse SQL scripts?  I am wanting to compare an SQL script (what it would create if executed) against an existing database.
0
P1ST0LPETE
Asked:
P1ST0LPETE
1 Solution
 
rob_farleyCommented:
The easiest way of doing this is to generate a new set of scripts, and compare them to the ones you already have.

So... not so much trying to parse, but just trying to compare a new version.

Rob
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now