Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL Database comparison and script generation

Posted on 2011-02-28
2
Medium Priority
?
530 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
  • 2
2 Comments
 
LVL 10

Accepted Solution

by:
Asim Nazir earned 2000 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 learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…

916 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