Is there any better API for work with SQL server objects? Or COM?

Thanks,

Alex

Well, I don't need to syncronize SQL 2000 and 2005 actually, and even if I need, I just need to syncronize common things like tables, procedures, functions, views, triggers. Mostly...

Thanks Jezemine,

Actually I've wrote such programm using in C#(using SQLDMO com object) myself. I think this elsasoft used the same com object:-)

So in case you need it, I can share,...

Thanks Mohammed.

Except the fact it doesn't script the tables and could not be used with SQL server 2000 it works perfect. I tested it - the easiest way to generate...

Thanks Dave.

Will test it right now.

I'm glad I'm not the only one who met this problem:-)

Thanks, Grant. I'll investigate these tools. May be you're right, and there is no need to spend hours generating some solution which is already built for us:-)

Thanks again!

Alex

Hey Grant!

What do you mean by SMO programming? The problem I have using T-SQL to generate CREATE scripts for those objects, which were modified (or simply saying for the list...

Thanks John.

Hope that'll help.