Getting stored procedures and permissions from 6.5 to 7.0

I am trying import my database from Sql Server 6.5 to 7.0 and can only
seem to get the tables.
I am using DTS and I can transfer the tables fine, but there doesn't
seem to be an option to move the other objects. There is a third button
that copies data between 7.0 databases, but that is greyed out since I
am coming from a 7.0 database.
There is a query button, but I don't how that would help me.
Thanks,
Tom.> I am trying import my database from Sql Server 6.5 to 7.0 and can only
> seem to get the tables.
> I am using DTS and I can transfer the tables fine, but there doesn't
> seem to be an option to move the other objects. There is a third
> button that copies data between 7.0 databases, but that is greyed out
> since I am coming from a 7.0 database.
You have to script your other objects to T-SQL script, but keep in mind that
your 6.5 stored procedures may need changing to work correctly in 7.0. You
may want to read in addition to above:
INF: Frequently Asked Questions - SQL Server 2000 - Upgrade
http://support.microsoft.com/defaul...b;en-us;q261334
INF: How to Upgrade SQL Server 6.5 and 7.0 to SQL Server 2000 (White Paper)
http://support.microsoft.com/defaul...b;en-us;Q322620
SQL Server Upgrade Recommendations and Best Practices
http://www.edgewoodsolutions.com/re...erUpgrade_1.asp
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||Although I suspect one of the articles Sebastion pointed you to contain this
information... You should consider using the database upgrade wizard... IT
should appear under a program group called "Microsoft SQL Server -
Switch"... It will move everything including permissions and logins...
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
news:40622890.4020207@.deltanet.com...
> I am trying import my database from Sql Server 6.5 to 7.0 and can only
> seem to get the tables.
> I am using DTS and I can transfer the tables fine, but there doesn't
> seem to be an option to move the other objects. There is a third button
> that copies data between 7.0 databases, but that is greyed out since I
> am coming from a 7.0 database.
> There is a query button, but I don't how that would help me.
> Thanks,
> Tom.
>|||Wayne Snyder wrote:

> Although I suspect one of the articles Sebastion pointed you to contain th
is
> information... You should consider using the database upgrade wizard... I
T
> should appear under a program group called "Microsoft SQL Server -
> Switch"... It will move everything including permissions and logins...
Found it.
I tried to run this and got the message "The local Sql Server is running
under LocalSystem priviledges, preventing the Upgrade Wizard to connect
to the Export Server". Why is this? How do I get it to run the way the
wizard wants?
Thanks,
Tom.

>