Download Shareware and Freeware Software for Windows, Linux, Macintosh, PDA

line Home  |  About Us  |  Link To Us  |  FAQ  |  Contact

Serving Software Downloads in 976 Categories, Downloaded 31.033.197 Times

PHP SQLDiff 2.2

  Date Added: June 01, 2010  |  Visits: 1.124


Report Broken Link
Printer Friendly Version

Product Homepage
Download (77 downloads)

PHP SQLDiff is a Web application that shows the difference between two SQL database tables. If you manage your database tables like I do, you also make copious copies of the tables. When I go to make any serious change to a table, I copy the table to another database and make my changes there. In other cases my users make changes to their tables using SQLView. Of course, I keep backups of their tables elsewhere. We know what we want, but its not always an easy thing to get. Here are a few things to keep in mind: Just as with any diff, the more that changed, the harder it is to see what really happened. SQLDiff provides scrolled sets of changed rows, but any way you cut it, a million changes is beyond what anyone can reasonably manage. The tables should have a primary key. SQLDiff does allow you to specify the column to use for the comparator. This means, however, that if your tables do not have the same primary key, then SQLDiff will not actually allow you to make changes. If you choose the wrong comparator column or the data for the column is not unique, you can serious mess up your tables. The two tables must be basically the same. That is, they must have the same column names and the datatypes for the columns must match. SQLDiff can compare tables that do not have exactly the same columns, but youll have to choose what columns to compare. It will also pretend that columns of the same name, but with a different datatype are the same. This is not always true, so you should be particularly careful when making changes to unlike tables. In any case, the more the tables differ, the more differences are found until you can hardly figure out what happened. Having said that, there are times when the change is that youve added or deleted a column or two. So SQLDiff will detect this and let you choose what columns you want to compare. In any case you still must have primary keys that match. Really really large tables can take a really really long time to diff. In order to do the compare, we must read the entire table and that can be pretty hard on your systems. If youve got a few tens of thousands of rows, SQLDiff should be satisfactory, but if youve got a few million rows, well... good luck. Theres a good chance PHP will run out of memory and depending on your web server configuration, you might not get anything back so you can tell whats going on. In general you will not be happy when comparing really large tables. Once the diff is known, you can make changes so certain (or all) rows or columns get updated in the master table from the modified table. Before actually commiting a database change, use the new Show SQL button and see if the SQL is reasonable. Databases are seldom static and SQLDiff does not even pretend to protect you. If you do a diff on a pair of tables and one of then changes afterwards and then you try to synchronize them with SQLDiff... well, you could be surprised..

Requirements: No special requirements
Platforms: Linux
Keyword: Administrative Frontents Changes Columns Database Php Php Sqldiff Really Sql Database Sqldiff Tables Web Web Application
Users rating: 0/10

License: Freeware Size: 573.44 KB
Database Tools  -  H2 Database Engine 1.0/2007-08-02
H2 Database Engine is a free SQL database engine writen in Java. JDBC and ODBC APIs are supported. Embedded and server modes are available. A Web console application is included. Clustering is supported.H2 Database Engine is a web based java...
5.2 MB  
Database Tools  -  SQL Database Professional
The SQL Database Professional data export module for Accurate Printer Monitor is used for recording/saving variables the parser receives and extracts from the stream of bytes into SQL-compatible databases, such as SQLBase, Oracle, Microsoft...
Libraries  -  SQL Database Professional plugin
The "SQL Database Professional" data publishing module for Advanced Serial Data Logger is designed for recording/saving variables the parser receives and extracts from the stream of bytes into SQL-compatible databases, such as SQLBase, Oracle, M...
Automotive Information Databases  -  Repair SQL Database Free 1.0
The service of repair SQL database: powered by Repair SQL Database Free, represents an efficient data recovery solution that can be applied in all instances of data corruption affecting the integrity of Microsoft SQL Server files. No doubts that...
1.88 MB  
Automotive Information Databases  -  SQL Database Recovery Free 1.0
Program SQL Database Recovery Free is able to recover the damaged data to the file (.mdf) database Microsoft SQL Server. The utility works by stepping through the algorithm. 1. SQL Database Recovery Free searches for and reads the service data...
1.91 MB  
Database Tools  -  SQL Database Studio
SQL Database Studio is modern professional client for Microsoft SQL Server. It enables you to effectively work with SQL Database. SQL Database Studio contains advanced features such as database comparison, GPS visualization, table lookups,...
6.04 MB  
Backup Utilities  -  Tool to Read SQL Database 1.0
SysTools MDF Viewer Software is the single solution to the most common queries like: how to open SQL database file?, how to read SQL database?, how to read MDF files? etc. SQL Database Reader Tool to read SQL database, open SQL database file and...
1.61 MB  
Database Tools  -  Cross Database Engine for PHP 1.0
CDEengine is a php library which aims to encapsulate the general database functions in PHP and provide a Cross Database Engine for php development where developers need to change the database but not their code.
Network & Internet  -  PHP SQLView 2.4
SQLView provides a user friendly interface for browsing a SQL database and modifying SQL tables using a Web browser. This is strictly an application to give users access to view and modify their SQL tables. PHP SQLView is not a tool to help...
409.6 KB  
Network & Internet  -  PHP Slideshow 0.9.9
PHP SlideShow is a little script that creates a web based slide show with NEXT and BACK buttons to navigate through a list of images. Optional features include multi-directory support and image descriptions. Setup is easy, just put the script...
9.22 KB  
Programming  -  FLEX-db Digital Asset Manager 3.0.9
FLEX-db - an enterprise Digital Asset Manager (DAM). It ingests and links metadata with files, creates thumbnails, and processes files using business rules. FLEX-db has a JSP client, Java app server for file input and output and an EJB metadata...
21.57 MB  
Programming  -  Libicom 0.9.0
The libicom library is a character based dynamicly linked library for Linux. It is used to remotely control the Icom IC-R8500 wide band receiver via an RS232 link. All call and return parameters to the control functions are character string based....
20.48 KB  
Programming  -  dotdesktop 0.3
Dotdesktop library provides ability to parse desktop entry file and access the information in a convenient way. Desktop entry file format is defined by, it is used to describe information about an application such as the name and...
327.68 KB  
Programming  -  Cedalion for Linux 0.2.6
Cedalion is a programming language that allows its users to add new abstractions and define (and use) internal DSLs. Its innovation is in the fact that it uses projectional editing to allow the new abstractions to have no syntactic limitations.
471.04 KB  
Programming  -  libyasl 0.2
Libyasl is a C++ class library to easily realize TCP/UDP/Multicast clientsand servers in IPv4 and IPv6 environments under GNU/Linux systems.
143.36 KB  
Database Tools  -  mel, XML Data Binding for C 2
Language: C, XMLLibrary: libxml2OS: AnyXML Databinding for C similar to JAXB, including but not limited to:.dtd to .[ch] production..xsd to .[ch] production (in progress)
53.07 KB  
Database Tools  -  CitrusDB 1.1.4
CitrusDB is an open source customer database application that uses PHP and a database back-end (currently MySQL). This software can keep track of customer information, CRM, services, products, billing, and customer service information. The...
1.1 MB  
Database Tools  -  MyJgui
MyJgui is a light-weight graphical user interface for MySQL databases. It aims to be easy to use for new users as well as experts. Motivation: After the MySQL Front project went commercial, there was no light weight, feature rich and free...
21.5 KB  
Database Tools  -  PHPCoder 1.4
PHPCoder is a web based front-end to the Turck MMCache encoding functions, which are similar to the Zend Encoder product. Turck MMCache is a free open source PHP accelerator, optimizer, encoder and dynamic content cache for PHP. It increases...
16.38 KB  
Database Tools  -  Rekall 2.2.6
Rekall is a database front-end, somewhat in the style of MicroSoft Access. However, Rekall is not itself a database, and does not include a database. By this we mean that data is stored somewhere else in an SQL server, and Rekall is fundementaly...
4.9 MB