On 4/10/2012 5:24 PM, Stephen Russell wrote: > On Tue, Apr 10, 2012 at 2:53 PM, Rafael Copquin > <[email protected]> wrote: >> I will answer my own question. Investigating the SQL Server Management >> Studio, I found the scripting tool is built into it. I ran it and >> generated a script of the database with all its objects (tables, >> constraints, indexes, etc) >> >> I ran it in the SQL Server Professional and it created the database and >> the tables as expected. > ------------------------ > > Go to www.red-gate.com > > Download the toolbelt and you can get a script to populate the data > in Production from dev. SQL Compare will compare the objects. SQL > Data compare will do just the data. > > This is expensive to buy. 1900 as a guess. The trial is free!
The Database and Schema Synchronization in SQLYog is AWESOME, and for my MySQL databases, is perfect for managing/syncing them. Cost I think was $99. You could get 19 of them if you wanted to spend as much! lol -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
