• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 535
  • Last Modified:

SQL Database comparison and script generation

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
Stanton_Roux
Asked:
Stanton_Roux
  • 2
1 Solution
 
Asim NazirCommented:
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
 
Asim NazirCommented:
Here is screen shot for Schema compare using Visual studio:
 VS Schema compare
Asim
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now