generate database schema

rgfriend · June 12, 2011 11:48AM

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

Thanks

David Atkinson · June 12, 2011 4:21PM

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 · June 12, 2011 5:58PM

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 · June 12, 2011 6:04PM

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 · June 12, 2011 6:35PM

Thanks, that is helpful

generate database schema

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk