Scripting out a database

  • Hi there,

    I have a SQL Server 2005 SP2 database that I have developed and want to deploy it to another environment which has to be done via a script.

    I have tried to script out the database and all objects using three separate tools and they all failed to resolve dependencies and resulted in a script that failed. Tools I have tried:

    Generate Scripts Tool in SQL Server 2005 SSMS

    redgate SQL Packager

    redgate SQL Compare (compared against a new empty database)

    Can anyone recommend a good tool that can produce a SQL script to create a schema from a database with the proper dependencies?

    Thanks,

    keymoo

  • RedGate SQLCompare is the best product I have seen for this. When you say it did not resolve dependencies do you mean it did not create something in the database? I have seen where the script created applies a Stored Procedure before a table is created and you get a message, but the procedure is still created.

    Have you checked the scripting and compare options in SQLCompare to make sure you have everything you need selected?

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply