Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL Database comparison and script generation

Posted on 2011-02-28
2
Medium Priority
?
528 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 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

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…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

721 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