No UDFs or SPs transferred from SQL 2000 to SQL 2005

Hi all
I just migrated by Databases from SQL Server 2000 to SQL Server 2005,
all tables are transferred but the SPs and UDFs have not been
transferred.
Q1: Is there a way to "automatically" transfer these objects ?
Q2: Do I have to manually transfer each one of them and perhaps do
extra processing like "recompile" these UDFs and SPs ?
Thanks a lot in advance.You could easily generate a change script using tools like red-gate's SQL
Compare or Apex SQL Diff.
--
Aaron Bertrand
SQL Server MVP
<rtoss1@.yahoo.com> wrote in message
news:1184859771.869668.194260@.o61g2000hsh.googlegroups.com...
> Hi all
> I just migrated by Databases from SQL Server 2000 to SQL Server 2005,
> all tables are transferred but the SPs and UDFs have not been
> transferred.
> Q1: Is there a way to "automatically" transfer these objects ?
> Q2: Do I have to manually transfer each one of them and perhaps do
> extra processing like "recompile" these UDFs and SPs ?
> Thanks a lot in advance.
>|||On Thu, 19 Jul 2007 12:07:31 -0400, Aaron Bertrand [SQL Server MVP] wrote:
> You could easily generate a change script using tools like red-gate's SQL
> Compare or Apex SQL Diff.
www.Quest.com has a free comparison tool, and I really like it.
-Chuck Lathrope
www.sqlwebpedia.com|||Use the backup / restore route to effect a complete migration of all
objects. Extended SPs, and those using deprecated functionality (like COM)
will need work to get them working, but all objects will be transfered.
<rtoss1@.yahoo.com> wrote in message
news:1184859771.869668.194260@.o61g2000hsh.googlegroups.com...
> Hi all
> I just migrated by Databases from SQL Server 2000 to SQL Server 2005,
> all tables are transferred but the SPs and UDFs have not been
> transferred.
> Q1: Is there a way to "automatically" transfer these objects ?
> Q2: Do I have to manually transfer each one of them and perhaps do
> extra processing like "recompile" these UDFs and SPs ?
> Thanks a lot in advance.
>