What are the challenges you face when working across database platforms? Take the survey
Options

generate database schema

rgfriendrgfriend Posts: 21 Bronze 2
edited June 12, 2011 6:35PM in SQL Compare Previous Versions
Is there a way in SQl Compare to generate database schema for an exisitng database?

Thanks

Comments

  • Options
    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?
    David Atkinson
    Product Manager
    Redgate Software
  • Options
    rgfriendrgfriend Posts: 21 Bronze 2
    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.
  • Options
    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
    David Atkinson
    Product Manager
    Redgate Software
  • Options
    rgfriendrgfriend Posts: 21 Bronze 2
    Thanks, that is helpful
Sign In or Register to comment.