Thread: [Squirrel-sql-users] Looking for ways to facilitate "diff" between two databases
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Karr, D. <dav...@wa...> - 2006-10-02 18:41:03
|
I was wondering whether SQuirreL can help me generate a "diff" report between two databases. I'm mostly concerned about getting DDL differences, but content diffs of a limited subset of tables would also be useful. I think I'll probably just have to write a Java utility to do this, but if SQuirreL can do part of this, that would be useful. |
From: Robert M. <rob...@gm...> - 2006-10-04 02:24:51
|
On 10/2/06, Karr, David <dav...@wa...> wrote: > I was wondering whether SQuirreL can help me generate a "diff" report > between two databases. I'm mostly concerned about getting DDL > differences, but content diffs of a limited subset of tables would also > be useful. I think I'll probably just have to write a Java utility to > do this, but if SQuirreL can do part of this, that would be useful. David, If you decide to write the utility yourself, consider giving it an open source license so that someone might turn it into a SQuirreL plugin in the future. Rob |
From: Robert M. <rob...@gm...> - 2006-10-04 07:03:46
|
On 10/2/06, Karr, David <dav...@wa...> wrote: > I was wondering whether SQuirreL can help me generate a "diff" report > between two databases. I'm mostly concerned about getting DDL > differences, but content diffs of a limited subset of tables would also > be useful. I think I'll probably just have to write a Java utility to > do this, but if SQuirreL can do part of this, that would be useful. > David, Right now with SQuirreL you are limited to selecting the "Columns" tab of a selected table and visually comparing the two table definitions. (This would be a few more steps ) but you could run "Create Table Script" on each table whose DDL is to be compared and save the defs to two files and diff with your favorite file editor (WinMerge, etc..) You can also select multiple tables when you chose "Create Table Script" and each table's DDL will be added to the SQL editor. Rob |
From: Matthew H. <hi...@po...> - 2006-10-05 15:57:38
|
What about using Create Table Script and Create Data Script to create text files which you could then run through diff? -M@ On Oct 2, 2006, at 11:40 AM, Karr, David wrote: > I was wondering whether SQuirreL can help me generate a "diff" report > between two databases. I'm mostly concerned about getting DDL > differences, but content diffs of a limited subset of tables would > also > be useful. I think I'll probably just have to write a Java utility to > do this, but if SQuirreL can do part of this, that would be useful. > > ---------------------------------------------------------------------- > --- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to > share your > opinions on IT & business topics through brief surveys -- and earn > cash > http://www.techsay.com/default.php? > page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
From: Robert M. <rob...@gm...> - 2006-10-05 21:32:04
|
On 10/5/06, Matthew Hixson <hi...@po...> wrote: > What about using Create Table Script and Create Data Script to create > text files which you could then run through diff? > -M@ It's crude but I've used this method before when pressed; and I recommended this to the original poster. Rob |
From: richard j. <rdj...@gm...> - 2006-10-06 01:38:04
|
Why not just use the xml file that the scheme data is stored in? True you have to turn on caching to get it to save the file but I would think that you could use it for your diff. Richard On 10/5/06, Robert Manning <rob...@gm...> wrote: > > On 10/5/06, Matthew Hixson <hi...@po...> wrote: > > What about using Create Table Script and Create Data Script to create > > text files which you could then run through diff? > > -M@ > > It's crude but I've used this method before when pressed; and I > recommended this to the original poster. > > Rob > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share > your > opinions on IT & business topics through brief surveys -- and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
From: Robert M. <rob...@gm...> - 2006-10-06 09:35:06
|
On 10/5/06, Robert Manning <rob...@gm...> wrote: > On 10/5/06, Matthew Hixson <hi...@po...> wrote: > > What about using Create Table Script and Create Data Script to create > > text files which you could then run through diff? > > -M@ > > It's crude but I've used this method before when pressed; and I > recommended this to the original poster. > > Rob Ah yes, but of course you didn't see my original post, because SourceForge was rejecting emails from GMail users at that point in time. Here is what I said in my post that was probably never delivered: David, Right now with SQuirreL you are limited to selecting the "Columns" tab of a selected table and visually comparing the two table definitions. (This would be a few more steps ) but you could run "Create Table Script" on each table whose DDL is to be compared and save the defs to two files and diff with your favorite file editor (WinMerge, etc..) You can also select multiple tables when you choose "Create Table Script" and each table's DDL will be added to the SQL editor. Rob |