我一直在与开发和现场生产数据库合作时对正确程序进行一些研究。 最好的一条规定是:。 数据库开发和部署战略,但我不能接受以下想法,即必须手工保存一份对非行所作的每一项变动的文件。 这对我来说似乎ous笑......
我使用
增 编
不对数据库设计进行改动,而不会产生被置于源头控制之下的改动文字。
然而,如果你已经处于这一治疗阶段,我建议购买红色库马克。 它将研究两个数据库和描述不同之处。 虽然——有时你们已经改变发展中国家数据库,但还没有把它推向 pro,而KolCompare没有办法知道。 最好在您的行文上打上文字(当表格目前存在时,不要打乱现有数据),并保持其源头控制,使之与你同时推动的其他法典保持一致。
唯一正确的方式是,使用或不使用管理演播室<>/strong>进行手工制作、检查、测试和操作文字。
www.un.org/Depts/DGACM/index_spanish.htm 页: 1
一项共同战略是保持一套定购的变更文字,例如,预定日期或数据库版本,从生产中开始提供新的支持,从而便于在发展数据库中测试。 在进行变革时,改变文字往往可以从服务器管理室生成,或者在出现更复杂的变化时可以人工操作。
另一项建议是将数据库定义(表格、程序等)加以控制。 可以通过利用Call服务器管理演播室,在每次更新后为所有物体制作文字,轻易做到这一点。 这样,你就能够很容易地比较随着时间的推移或不同环境的变化。
I m trying to export some tables from SQL Server 2005 and then create those tables and populate them in Oracle. I have about 10 tables, varying from 4 columns up to 25. I m not using any constraints/...
In our database we have an SQL server account that has the correct roles to access some of the databases. We are now switching to windows authentication and I was wondering if we can create a NT user ...
I have been trying to execute a MS SQL Server stored procedure via JDBC today and have been unsuccessful thus far. The stored procedure has 1 input and 1 output parameter. With every combination I ...
Is it possible to use the sqlcmd command to dump table structure the way it can be done with mysqldump?
Hi I have the following SP, however when I use LINQ to SQL it generates 2 multiple recordsets. For my sanity I am trying to fathom out what it is in the stored procedure that is doing this and would ...
I want to create a table in MS SQL Server 2005 to record details of certain system operations. As you can see from the table design below, every column apart from Details is is non nullable. CREATE ...
I love the new DATE datatype in SQL Server 2008, but when I compare a DATE field to a DATETIME field on a linked server (SQL 2005, in this case), like this: DECLARE @MyDate DATE SET @MyDate = CONVERT(...
How to determine if a Transaction is active i.e. before issuing Begin Transaction I want to ensure that no previous transaction are open.. the platform is VB6, MS-SQL Server 2000 and ADO 2.8
