My project's "live" data is currently in an SQL 2000 database. I was
running a development copy of SQL 2000 on my local development machine.
When needed, I just used DTS to grab a current copy of the database
tables including the table definitions and their current contents as
well as the custom stored procedures installed by another developer.

We are now moving to SQL Server 2005. I have installed the developer
version on my local development machine. I now want to copy the data
from the SQL Server 2000 live server to my local machine. I figured out
how to copy the table structures and data but not the custom stored
procedures. What am I missing?

Any help greatly appreciated...

--
"There are 10 kinds of people in the world:
those that understand binary and those that don't." - Unknown

Hello Greg,

You are probably using a Data Flow task to move the data and have it create
the table structure right? That's fine but the Data Flow task is all about
data. To move the procs you can either script them out or you can use the
TRansfer SQL Server Objects task. You may also want to Restore the 2000
Db to 2K5 though right? Be easier (Remember to update stats though)




Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com