Question

I have a project that involves Software as a Service. The app has one SystemDB and multiple customer databases. The customer databases are exactly the same(all tables are equal). The system databases contains a table with all the details from the customer databases like dbname, dbPassword,dbUsername, etc..

How can i do an update to all databases and make sure that the update is correct. For example. all db s have a translation table. I want to add a word to all tables. Or i want to update a word that has been misspelled. I have more than 50 db s that we are going to maintain. so manual work is not possible.

关于能够做到这一点的软件或框架的任何建议。

我正在使用PHP5.4.0,但还没有具体框架。作为非行,我们使用MS Sql 2008R2

感谢

Answer 1

We have simillar situation to read from multiple database,our pl is C#.net. For that we have written a C#.net code which runs and connect to each database one by one and manages the data into a single server. I suggest you to go that way only and whatever scripts like update or insert sripts should be used as Excecute Query in .Net. In this we you will avoid manual work of connecting and updating.

Answer 2

我将采用这种复制方法,而这种复制得到SQ服务器的默示支持。复制允许你在你的系统数据库(出版商)上公布某些表格,并订阅一个或多个客户数据库(用户)的数据变动。由于你只是把数据推向一个方向,并且正在反映某些表格和系统数据库,这将对你有益。

你们可以从SSMS中推广。扩大目标探索者服务器下的复制处,正确点击“当地出版物”和选定出版物。委托人将通过出版过程指导你的工作。订阅费相同,为每个客户数据库设定订阅费。

由于你拥有许多客户数据库,因此,在使用t-sql创建订阅时,你将值得使用,然后在你的所有目标数据库中复制这一代码。查阅说明如何做到这一点。

Answer 3

使用数据库的触发点是更新其他数据库中的表格。

Answer 4

i 恐怕没有魔.。但是,如果你们真的喜欢使用口服体液处理法。这使得生活更加容易。

我投赞成票

Doctrine ORM -

也有许多其他人。 Propel,。

友情链接