Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Urgent - simplest way to move SPs
Message
From
27/06/2008 10:18:46
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01327106
Message ID:
01327239
Views:
7
This message has been marked as a message which has helped to the initial question of the thread.
>Hi everybody,
>
>What is the simplest way to move several SPs (I have create scripts (with DROP) for all of them as different files) to production?
>
>Thanks a lot in advance.
>
>One way would be to put all the scripts into one file, another would be to execute in a batch. The second way was discussed here before, but I don't recall right now...

We maintain 1 file/SP. Each SP is under source control and versioned like any other project artifact.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform