Bug 244723

Summary:	sqlsync-1.0.0_rc1.ebuild (New package)
Product:	Gentoo Linux	Reporter:	Grzegorz Chwesewicz <grzegorz.chwesewicz>
Component:	New packages	Assignee:	Default Assignee for New Packages <maintainer-wanted>
Status:	CONFIRMED ---
Severity:	enhancement
Priority:	High
Version:	unspecified
Hardware:	All
OS:	Linux
URL:	http://silvercoders.com/index.php?page=sqlsync
Whiteboard:
Package list:		Runtime testing required:	---
Attachments:	sqlsync-1.0.0_rc1.ebuild

Description Grzegorz Chwesewicz 2008-10-28 09:06:50 UTC

SqlSync utility gives you the ability to compare data stored in two SQL databases, and synchronize it. Results contain list of records that differ, records that are missing and records that are additional. SqlSync can generate SQL queries that will change second database in such a way, that it will be identical to first database.
Generated queries can be executed automatically. It will synchronize selected objects in databases or whole databases.

You can control the process using command line arguments, and results are readable for user, but on the other hand, easy for future processing using shell scripts. There is a C language library included in the package, that allows comparing databases from other applications.

SqlSync supports at least following SQL servers: PostgreSQL 8.1.x, MySQL 5.0.x, FirebirdSQL 1.5.x, Microsoft SQL Server 2000, Microsoft SQL Server 2005, Oracle 10g. Two databases that are being compared can be driven by two different SQL servers.

You can find more detail description on http://www.linux.com/feature/134127 .

Comment 1 Grzegorz Chwesewicz 2008-10-28 09:08:17 UTC

Created attachment 170067 [details]
sqlsync-1.0.0_rc1.ebuild

Comment 2 Grzegorz Chwesewicz 2008-10-28 09:14:45 UTC

You should rename sqlsync-1.0.0-rc1.ebuild to sqlsync-1.0.0_rc1.ebuild (change '-' to '_') to ebiuld work correctly.