Solved

SQL Database comparison and script generation

Posted on 2011-02-28
2
526 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

Comparison of Amazon Drive, Google Drive, OneDrive

What is Best for Backup: Amazon Drive, Google Drive or MS OneDrive? In this free whitepaper we look at their performance, pricing, and platform availability to help you decide which cloud drive is right for your situation. Download and read the results of our testing for free!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Compare a column in results by values left of decimal 2 34
SQL Select Query help 1 51
Please explain the difference between EXCLUDE, INTERSECT and JOIN 7 52
SQL query 45 41
     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

752 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