473,769 Members | 6,126 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Database compare software question

Hello. I have an information question. In my work I often have to
compare databases between releases in order to upgrade them to needed
version of software we developing.
And I am looking for software that could do that. It doesn't have to
be free, but have to be good.
I need to be able to compare table structures, amount of rows,
procedures, triggers.
I found one: Red Gate , but I am not sure that it is the best in the
market, and it is pretty expensive too.
Any suggestions are appreciated.
Thank you in advance.
Jul 20 '05 #1
3 1869

"inna" <me****@hotmail .com> wrote in message
news:34******** *************** ***@posting.goo gle.com...
Hello. I have an information question. In my work I often have to
compare databases between releases in order to upgrade them to needed
version of software we developing.
And I am looking for software that could do that. It doesn't have to
be free, but have to be good.
I need to be able to compare table structures, amount of rows,
procedures, triggers.
I found one: Red Gate , but I am not sure that it is the best in the
market, and it is pretty expensive too.
Any suggestions are appreciated.
Thank you in advance.


I use Red Gate, and I would say that it's one of the cheaper options in the
market for what it does, although I appreciate that what is cheap for one
company may be expensive for another. USD195 is not much money compared to
some other tools (and compared to the cost of MSSQL itself, a developer's
time etc.). For example, Embarcadero has a suite of products for schema
comparison, synchronization etc., and they are arguably much more powerful
than Red Gate, however the cost is significantly higher.

Simon
Jul 20 '05 #2
Hi

This request gets posted almost daily in this news group. By far the best
way to control this is through correct source code control, so you can
script any version of the database at any time.

SQL Server Magazine www.sqlmag.com had a product at reviewed from
www.e-dule.com

You may want to browse/search Google for other postings.

John

"inna" <me****@hotmail .com> wrote in message
news:34******** *************** ***@posting.goo gle.com...
Hello. I have an information question. In my work I often have to
compare databases between releases in order to upgrade them to needed
version of software we developing.
And I am looking for software that could do that. It doesn't have to
be free, but have to be good.
I need to be able to compare table structures, amount of rows,
procedures, triggers.
I found one: Red Gate , but I am not sure that it is the best in the
market, and it is pretty expensive too.
Any suggestions are appreciated.
Thank you in advance.

Jul 20 '05 #3
"inna" <me****@hotmail .com> wrote in message
news:34******** *************** ***@posting.goo gle.com...
Hello. I have an information question. In my work I often have to
compare databases between releases in order to upgrade them to needed
version of software we developing.
And I am looking for software that could do that. It doesn't have to
be free, but have to be good.
I need to be able to compare table structures, amount of rows,
procedures, triggers.
I found one: Red Gate , but I am not sure that it is the best in the
market, and it is pretty expensive too.
Any suggestions are appreciated.

Another that might be examined is at:
http://www.ssw.com.au/SSW/SQLTotalCompare/

Jul 20 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
2832
by: democratix | last post by:
Hi, I've only got a couple years experience developing for Access but have recently been experimenting with HTML/javascript for gui and client-side scripting, mysql for database and php for server-side scripting. I've been running it all on the development machine until the application I'm building is advanced enough to start optimising/testing with network lag in mind. So it's no slower, and in some ways at least it seems faster.
346
16632
by: rkusenet | last post by:
http://biz.yahoo.com/rc/040526/tech_database_marketshare_1.html Interesting to see that database sales for windows is more than Unix.
1
1813
by: poppybush | last post by:
I am working on a windows application that allows a system administrator to assign users to specific software titles. Let's say that there are 5 available licenses for Visual Studio but 6 users need the software at one time. What I did was create an OC table (out-of-compliance) and added the 6th person to that table. I've also created a feature in the software that allows the admin to add additional licenses to the database. Is there a...
14
2285
by: kdv09 | last post by:
Hi! I'm looking for some help in fixing my screwup: I've got C++ app which reads MDB database, using MFC CDatabase and CRecordset derived classes. I had it working OK on development PC (Win XP SP2) with MS Access 2000 installed (the app itself does not use MS Access). I moved the app on another PC (also Win XP SP2) without MS Access. After some poking around I've figured out that the app does not work because DSN it is using was not...
1
2187
by: relisoft | last post by:
SEATTLE, Washington. - July 12, 2006: Reliable Software® announces the upcoming release of Code Co-op® version 5.0. Code Co-op is an affordable peer-to-peer version control system for distributed development enabling collaboration through Email, LAN, or VPN-no server required. The upcoming release of Code Co-op 5.0 is due out this fall. With this release Reliable Software continues its track record of innovation by introducing...
15
4111
by: chaseexchange | last post by:
First, a brief explanation of why this has happened. I purchased, what I thought, was a fully functional program written in Access last year from a local programmer. This program was to be used as my POS for an online DVD store. It turns out that what the programmer actually gave me was a "license" to use his software. This was not the agreement we made, and he knows this. He took advantage of the fact that I knew very little about...
3
2905
by: RichardLamont | last post by:
We often have to migrate changes to sql server 2000 databases from development to production. Normally we dump the sql from Enterprise Manager for production and development and do a diff (using CSDiff - downloadable for free). From the diff information we create some scripts to add new tables or alter existing tables as required. This is time consuming and error-prone. I am now trying the following: 1. Backup up the Development...
0
3321
by: Jack | last post by:
Training Classes for Oracle10g, 9i, 8i Certification training in Oracle10g and 9i: DBA, Developer, Discoverer. training conducted at your location worldwide. Courseware licensing also available. http://a.uuload.com/Oracle-Database.htm Unlock the Value of Your IT System Confio Software's Ignite for Oracle uses wait-event analysis to improve database performance by 65% or more. Gain visibility of every Oracle wait event. Download free...
0
3296
by: Winder | last post by:
Training Classes for Oracle10g, 9i, 8i Certification training in Oracle10g and 9i: DBA, Developer, Discoverer. training conducted at your location worldwide. Courseware licensing also available. http://a.uuload.com/Oracle-Database.htm Unlock the Value of Your IT System Confio Software's Ignite for Oracle uses wait-event analysis to improve database performance by 65% or more. Gain visibility of every Oracle wait event. Download free...
0
9589
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10045
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9994
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9863
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8872
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7409
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5447
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3959
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2815
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.