Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Create a Repository Workspace for a SQL-SERVER database?

Questions
Tags
Users
Badges
Dan Roche
(11●1) Jan 23 '18, 6:47 p.m.

 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.

0 votes

1 answer
5,717 views
0 votes

One answer

Permanent link
Donald Nong
(14.5k●6●14) edited
Jan 23 '18, 6:57 p.m.

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).
https://jazz.net/help-dev/clm/topic/com.ibm.team.concert.dotnet.doc/topics/t_working_with_repository_workspaces.html

0 votes

Comments
Dan Roche
Jan 23 '18, 7:44 p.m.
 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!

Donald Nong
Jan 23 '18, 11:23 p.m.
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.

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,147
× 82

Question asked: Jan 23 '18, 6:47 p.m.

Question was seen: 5,717 times

Last updated: Jan 23 '18, 11:23 p.m.

Confirmation Cancel Confirm