SMO Scripter generated script does not run on SQL 2000

Question

I seem to be running into a problem getting a script (of the entire db) generated by SMO to run on 2000.  It looks like it puts all kinds of SQL 2005 specific TSQL in the script, which fails on 2000.  Any ideas?

Angelo

Answer 1

SMO allows you to set the target version. When the version is set to Version80, SMO will filter out or alter the DDL as appropiate. For example, if you are using the Transfer class, you can do the following:

Transfer trans = new Transfer(db);
trans.Options.TargetServerVersion = SqlServerVersion.Version80;

I am not sure of your exact scenario, but if this does not help you please be more specific on what you are trying to do.

Peter

Answer 2

Thanks Peter,

I can't believe I missed that. Looks like it did the trick.

Angelo