[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1643
  • Last Modified:

.PRC

I only know .sql, how do you create a .PRC for a stored proc?  We're moving our stored procs to VSS and I don't see how my collegues got the .PRC files created or even moved to VSS.
0
dba123
Asked:
dba123
  • 3
  • 2
1 Solution
 
gpompeCommented:
They probably just renamed the file to PRC
0
 
ShogunWadeCommented:
it is better to save files as .sql  than .prc   .prc means you need to fiddle with file tpye associations to open them easily.

simply script up the procedures and save them.
0
 
gpompeCommented:
With Visual Studio you can integrate VSS to manage the code. I am not sure but maybe is Visual Studio who generate the PRC.

But is always a plain text file you can call in the way you want.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
gpompeCommented:
When you use a DTS with a Copy SQL Server Objects Task, this will generate a PRC for the procedures, a TAB file and so on.

This task place the file in the "Script file directory" you setup in the task.
0
 
dba123Author Commented:
Ok, I got it.  My boss has a new process for us to upload stored procs, etc. to VSS 2005.  I didn't get where .prc came from because he's using Enterprise Manager 2000 and I'm using Management Studio 2005. I didn't want to bug him but learned that 2005 doesn't have an option any longer to save procs as .prc...and I've always saved ANY script as a .sql.

thus the confusion!!
0
 
dba123Author Commented:
We are already integrated with VS and VSS, this was the DB side of things for our stored procs.
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now