Create a Repository Workspace for a SQL-SERVER database?
In RTC, How can I create a "Repository Workspace" from an existing SQL SERVER database to start versioning its stored procedures, functions, etc? Is it even possible? Thanks. |
One answer
Repository Workspace is a concept in RTC, or a data structure stored in the database. It has nothing to do with the vendor of the database (be it SQL Server or not).
Comments I guess I didn't express myself correctly. I have a "MyBigDatabase" with lots of tables, lots of stored procedures, functions, etc. I have a team of DBA developers that are constantly updating the stored procs and functions. I want to start having versions of the stored procs. I wonder if RTC can read the current database objects and store them in a RTC repository... automatically and then we can start checking-out and checking-in the stored procs (and get them sent back to the database)? Is it something RTC can do? Thanks! If you are talking about native support, I believe the answer is no. If you save the stored procedures as text files, then you should be able to put these text files into RTC repository.
|