August 13, 2008 at 8:42 am
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
August 13, 2008 at 8:54 am
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?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply