I am a data base developer. I have to implement SCM system in my department which is Perforce. Our oracle developers never used source control systems before. Does anyone manage oracle schema by putting it in Perforce?
Source control products are designed for source code, not for databases. They work on line-by-line differences in the code.
When a database developer needs to revert to an earlier version of an object, such as a view or stored procedure, the entire database must be considered, to account for dependencies. Unfortunately, using a source control product, the developer would see only the line-by-line differences in the SQL script for the particular object. There would be no cross-referencing to dependencies.
If it's a Perforce, what's the best way to do it? Or, probably, there is something else? Please help.
Source control products are designed for source code, not for databases. They work on line-by-line differences in the code.
When a database developer needs to revert to an earlier version of an object, such as a view or stored procedure, the entire database must be considered, to account for dependencies. Unfortunately, using a source control product, the developer would see only the line-by-line differences in the SQL script for the particular object. There would be no cross-referencing to dependencies.
If it's a Perforce, what's the best way to do it? Or, probably, there is something else? Please help.
Comment