generate database schema

rgfriend

Is there a way in SQl Compare to generate database schema for an exisitng database?

Thanks

David Atkinson

It depends what you mean.

If you want to create a new database based on another. Simply create a blank database using SSMS, and set this as the target in SQL Compare. This will let you create a script to build the schema based on your source database.

Is this what you were hoping to achieve?

rgfriend

Thank you, that's exactly what I want, I tried it works.
What's the difference using Sql server manamgent studio- generate script,
and Redgate, for this purpose to create a schema for exsiting database.

David Atkinson

In theory they should perform the same task. However, we have heard reports from our users that Red Gate's script is much more more reliable in terms of dependency ordering of the object creation statements. I'd suggest that you verify this for yourself by using SQL Compare in its trial period.

SQL Compare's principal advantage is that it can create a diff script to push changes from one database to another.

Hope this helps,

David

rgfriend

Thanks, that is helpful