Solved

SQL Database comparison and script generation

Posted on 2011-02-28
2
525 Views
Last Modified: 2012-05-11
Hi There

I have a database in a dev environment that I have full access to and admin rights ,I also have another database in live environment that we only have view permissions on.

I am looking for a programme that I can use to compare the two database and that will generate update or create scripts so that I can give those scripts to the network administrator so he can run them on the live environment.

I am not to worried about the data all I am really interested in is updating the changes made to the tables and stored procedures. As well as creating any new stored procedures tables or views.

I dont mind buying a programme or using a free programme

Thanks
Stanton



0
Comment
Question by:Stanton_Roux
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 10

Accepted Solution

by:
Asim Nazir earned 500 total points
ID: 35004556
Hi,

You can use Visual Studio's Compare Schema option or you can download SQLDelta from
http://www.sqldelta.com/ 
Both works the same way. I have used both and works great.

Let me know if you need more help.

Asim
0
 
LVL 10

Expert Comment

by:Asim Nazir
ID: 35004571
Here is screen shot for Schema compare using Visual studio:
 VS Schema compare
Asim
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to search for strings inside db views 4 39
SQL Improvement  ( Speed) 14 37
SQL Server - Set Field Values ito Zero Based on Related Table 4 44
GeoClustering  and AOG 25 43
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question