DB Compare 1.0 Install

Rating: No reviews yet
Downloads: 1277
Released: Feb 25, 2012
Updated: Jun 17, 2012 by CorbyNichols
Dev status: Stable Help Icon

Recommended Download

Application DB Compare Install
application, 710K, uploaded Feb 25, 2012 - 1277 downloads

Release Notes

If you like any of my projects you can help support my web site www.daily-click.com which is dedicated to using technology to helping people and animals; You can make a donation of any amount $3 and up or by telling your friends, family and coworkers about my web site. Daily-Click.com offers free email and text messaging services to pet guardians and / or emerency contacts if a user does not 'Check In' at the times they selected or in the event of an emergency. Perfect for anyone who lives alone, especially pet owners and seniors.

The source code consists of a Visual Studio 2010 solution that contains two projects.

DataClassBuilder.Net.Dll - This is the main code generation engine of RAD Studio Code Generation Toolkit, located at http://radstudio.codeplex.com .

In my completely biased opinion RAD Studio is the best C# code generator / data tier creator / stored procedure generator for C# and other .Net developers.

In addition to the time savings that DB Compare saves me, I built this project to demonstrate RAD Studio Code Generation Toolkit. I think more developers would use it if they knew about it and how to use it property.

Hopefully this project will become popular and also increase the popularity of RAD Studio, as there is alot of very useful code in the program.

One last thing, if you do wish to work on the code, I have another project called Regionizer, which is a Visual Studio Package that docks in the toolbar where the Solution Explorer or Properties Window is located, and will format a C# document into regions for Private Variables, Methods, Constructors, Events and Properties.

http://regionizer.codeplex.com

About DB Compare:

DB Compare is a simple tool that compares two instances of SQL Server and compares the of the tables, views and stored procedures to make sure they are up to date.

To use the tool enter a connection string for the source database and target database and a Comparison Report is generated on screen that will report if the databases are equal or if they are not equal any differences are shown.

This is a sample project built using RAD Studio Code Generation Toolkit, which is located at http://radstudio.codeplex.com .

The next release of RAD Studio will include this project, but I am swamped at the moment so I did not want to delay the release of DB Compare as I feel many developers will find it useful.

Another reason I made this project as a seperate release is that this project has a wider appeal as any SQL Server developer that works with local and production (or off site) copies of a database.

Here is a short scenario of what this tool saves me, perhaps you have similiar job duties.

I often have to maintain off site databases and ensure they are synchronized with my local development instances, but to ensure they are up to date I usually have to perfrom the following:

1. Script all tables, views and procedures from my development machine.
2. Script local records that are on the product machine so I can reinsert them after the schema is updated.
3. Execute the new schema on the production database(s).
4. Reinsert the local records that are required to run

Now with DB Compare, I can script only the items that have changes, if any.

My other Codeplex Projects:

Rad Studio Code Generation Toolkit
http://radstudio.codeplex.com

DataJuggler.Web.Controls
http://datajugglercontrols.codeplex.com

Regionzer
http://regionizer.codeplex.com

SmoothPopup
http://smoothpopup.codeplex.com

Reviews for this release

No reviews yet for this release.