script integration with vss using ssms

Question

Post reply

script integration with vss using ssms

SQL*

SSCertifiable

Points: 6638
More actions
April 8, 2009 at 3:45 am

#129160

hi,
i've upgrade the SQL2000 databases to SQLSERVER2005. Now i want to use SSMS to maintain versioning. How can i use the existed stored procedures,triggers.. and other objects.
🙂

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

SQL* SSCertifiable Points: 6638 More actions · Answer 1

hi all,

i need to integrate the SSMS With VSS Please provide usefull information.

thanks.

🙂

ChiragNS One Orange Chip Points: 26137 More actions · Answer 2

You will need to create a new solution and project from SSMS. Then you can add the prject you have created to vss. To do this open the project in ssms and in solution explorer right click on the project and click Add project to source safe.

Then you can add your scripts to the project and check in from ssms.

"Keep Trying"

ChiragNS One Orange Chip Points: 26137 More actions · Answer 3

Another way is to create the project from ssms, add the scripts to the project and then add the solution to vss.

"Keep Trying"

SQL* SSCertifiable Points: 6638 More actions · Answer 4

thanks chirag,

ur post is useful to me. is there any way to add folders for sps,functions,triggers..etc.,

thanks.

🙂

ChiragNS One Orange Chip Points: 26137 More actions · Answer 5

Yes.

In vss there is a solution under which there are different projects. In vss this solution is the parent folder under which you have folders for each projects.

Here is how i do it. Say i have solution called test solution under which i have StoredProcedures & Functions.

In vss the folder structure would be 1) BaseVss folder\Test solution\StoredProcedures.

2) BaseVss folder\Test solution\Functions.

"Keep Trying"