Migration from v7 to 2000 Q

We use a custom application written by a software company that are no longer
trading.
The back-end of the application runs on SQL7. We are currently implementing
a small business server 2003 system with SQL 2000. I would therefore like to
move the backend onto SQL 2000 (small biz).
I have tried to migrate to the database using the backup option on sql7 and
then restore on sql2000.
The problem I have come across is although it copies the data, it doesn't
copy the stored procs and views over. For this reason (I assume) the front
end stops working. When you run the application it stops asking for the
location of a view.
Is it possible to migrate the stored procs and views? What are my chances of
success. Sorry for the vagueness of the question, but SQL server admin
really isn't my thing. If you need more info please let me know.
TIA,
HH,
Backup/Restore detach/attach both copy everything in the database including
views and stored procedures. Do you not see the views and stored procedures
in Enterprise Manager when you move from 7 --> 2000? Who owns these views
and stored procedures i.e., dbo?
HTH
Jerry
"H" <walesforthegr@.ndslam.com> wrote in message
news:O$$5AHQyFHA.3812@.TK2MSFTNGP09.phx.gbl...
> We use a custom application written by a software company that are no
> longer trading.
> The back-end of the application runs on SQL7. We are currently
> implementing a small business server 2003 system with SQL 2000. I would
> therefore like to move the backend onto SQL 2000 (small biz).
> I have tried to migrate to the database using the backup option on sql7
> and then restore on sql2000.
> The problem I have come across is although it copies the data, it doesn't
> copy the stored procs and views over. For this reason (I assume) the front
> end stops working. When you run the application it stops asking for the
> location of a view.
> Is it possible to migrate the stored procs and views? What are my chances
> of success. Sorry for the vagueness of the question, but SQL server admin
> really isn't my thing. If you need more info please let me know.
> TIA,
> H
>|||Take a look at the Copy Database Wizard which should help pick up objects,
such as Stored Procedures, stored in the Master database.
--
Hal Berenson, President
PredictableIT, LLC
"H" <walesforthegr@.ndslam.com> wrote in message
news:O$$5AHQyFHA.3812@.TK2MSFTNGP09.phx.gbl...
> We use a custom application written by a software company that are no
> longer trading.
> The back-end of the application runs on SQL7. We are currently
> implementing a small business server 2003 system with SQL 2000. I would
> therefore like to move the backend onto SQL 2000 (small biz).
> I have tried to migrate to the database using the backup option on sql7
> and then restore on sql2000.
> The problem I have come across is although it copies the data, it doesn't
> copy the stored procs and views over. For this reason (I assume) the front
> end stops working. When you run the application it stops asking for the
> location of a view.
> Is it possible to migrate the stored procs and views? What are my chances
> of success. Sorry for the vagueness of the question, but SQL server admin
> really isn't my thing. If you need more info please let me know.
> TIA,
> H
>