PHPackages                             suramon/sf-propel-sql-diff-plugin - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. suramon/sf-propel-sql-diff-plugin

ActiveLibrary[Database & ORM](/categories/database)

suramon/sf-propel-sql-diff-plugin
=================================

Generate diff.sql file, which contains difference between schema.yml and current database structure

0.4.1(9y ago)03.7kLGPLPHP

Since Oct 5Pushed 9y ago1 watchersCompare

[ Source](https://github.com/SuRaMoN/sf-propel-sql-diff-plugin)[ Packagist](https://packagist.org/packages/suramon/sf-propel-sql-diff-plugin)[ RSS](/packages/suramon-sf-propel-sql-diff-plugin/feed)WikiDiscussions master Synced 1w ago

READMEChangelogDependenciesVersions (11)Used By (0)

```
= sfPropelSqlDiffPlugin =
[[PageOutline]]

sfPropelSqlDiff plugin generates database sql patch, which contains difference beetween schema.yml and current database structure.

== Description ==
It provides new symfony task - propel:build-sql-diff which will create file propel.diff.sql with ALTER TABLE statements, whitch will make current database structure
exactly as it described in schema.yml without deleting data in tables as it does propel:build-sql task.

Currently it handles:
 - creation and deletion of tables/fields/indexes/foreign keys
 - changing fields/indexes/foreign keys

Plugin is in beta state now. It is tested only for mysql. You can discuss it at [http://www.symfony-project.org/forum/index.php/t/10679/ thread in symfony forum]

== Usage ==

After making changes in schema.yml
  {{{
  php symfony propel:build-sql-diff
  }}}

Then you can find sql file at data/sql/propel.diff.sql

To execute propel.diff.sql
  {{{
  php symfony propel:insert-sql-diff
  }}}

To run model rebuild and apply database changes to database
  {{{
  php symfony propel:build-all-diff
  }}}

You can also specify connection name if you have more than one database, application name, environment. For more info please take a look at
  {{{
  php symfony help propel:build-sql-diff
  }}}
```

###  Health Score

29

—

LowBetter than 57% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity16

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity59

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~106 days

Recently: every ~209 days

Total

10

Last Release

3379d ago

### Community

Maintainers

![](https://avatars.githubusercontent.com/u/852196?v=4)[SuRaMoN](/maintainers/SuRaMoN)[@SuRaMoN](https://github.com/SuRaMoN)

---

Top Contributors

[![SuRaMoN](https://avatars.githubusercontent.com/u/852196?v=4)](https://github.com/SuRaMoN "SuRaMoN (1 commits)")

### Embed Badge

![Health badge](/badges/suramon-sf-propel-sql-diff-plugin/health.svg)

```
[![Health](https://phpackages.com/badges/suramon-sf-propel-sql-diff-plugin/health.svg)](https://phpackages.com/packages/suramon-sf-propel-sql-diff-plugin)
```

###  Alternatives

[jdorn/sql-formatter

a PHP SQL highlighting library

3.8k117.8M121](/packages/jdorn-sql-formatter)[backup-manager/backup-manager

A framework agnostic database backup manager with user-definable procedures and support for S3, Dropbox, FTP, SFTP, and more with drivers for popular frameworks.

1.7k1.6M11](/packages/backup-manager-backup-manager)[propel/propel1

Propel is an open-source Object-Relational Mapping (ORM) for PHP5.

8351.6M88](/packages/propel-propel1)[insolita/yii2-migration-generator

Set of gii tools for generating files for migration by schema of table , phpdoc or table data

108508.0k5](/packages/insolita-yii2-migration-generator)[xpdo/xpdo

A PDO-based Object/Relational Bridge Library

7088.4k4](/packages/xpdo-xpdo)[voku/session2db

A PHP library acting as a wrapper for PHP's default session handling functions which stores data in a MySQL database, providing both better performance and better security and protection against session fixation and session hijacking.

2920.0k](/packages/voku-session2db)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)