How to migrate SQL 2000 stored procedures and UDFs to VS 2005?
- From: "C17" <c17@xxxxxxxxxxxxxxxx>
- Date: Tue, 17 Apr 2007 16:26:15 -0400
Hi all -- apologies in advance if this should be posted in another newsgroup
(which one??)
I have migrated an application from:
VS 2003 + SQL Server 2005
to
VS 2005 + SQL Server 2005
The migration went smoothly, and the application and database are working
fine in 2005.
I have 100+ stored procedures and UDF's inside my database. Now, I would
like to take advantage of the new features in VS 2005. I understand that
it's possible to:
a) Manage stored procedures and UDF's inside VSS
b) Version-control their source code from inside VSS in the same manner
as code
c) Rewrite them using VB or C# from inside VSS
Trouble is, I can't find any tutorials or documentation on how to do this
upgrade/migration for EXISTING sprocs and UDFs. All the examples I've seen
assume you're starting an application from scratch.
(I guess what I expected to see is some wizard that lets you extract the
existing sprocs/UDFs in my database and bring them into VS....or something
like that.)
Can someone either explain at a high level how to do it, or point me to some
resources?
Thanks!
C17
.
- Prev by Date: Navigation Bar gone
- Next by Date: Re: Navigation Bar gone
- Previous by thread: Navigation Bar gone
- Next by thread: Can not add a reference to my old VB6 dll file on my development computer
- Index(es):
Relevant Pages
|
