Importing Sql 6.5 data

I am trying to move my data from Sql Server 65 on Windows NT 4 to my Sql
Server 7.0 on W2K and can only seem to move the tables, but not the
objects (such as stored procedures) using DTS.
Is there a way to easily move/transform the whole database from 65 to 7?
Thanks,
Tom.Only DTS type which includes other stuff than tables is the Object Transfer. And that is not
available when you go from 6.5 (as I remember). You can scrip the stuff to move proc's etc over, or
use the Upgrade Wizard which comes with SQL7.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Thomas Scheiderich" <tfs@.deltanet.com> wrote in message news:3FC3F4AB.9050601@.deltanet.com...
> I am trying to move my data from Sql Server 65 on Windows NT 4 to my Sql
> Server 7.0 on W2K and can only seem to move the tables, but not the
> objects (such as stored procedures) using DTS.
> Is there a way to easily move/transform the whole database from 65 to 7?
> Thanks,
> Tom.
>|||Tibor Karaszi wrote:
> Only DTS type which includes other stuff than tables is the Object Transfer. And that is not
> available when you go from 6.5 (as I remember). You can scrip the stuff to move proc's etc over, or
> use the Upgrade Wizard which comes with SQL7.
>
Where would I find the Upgrage wizard?
Thanks,
Tom.
"Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
news:3FC3F4AB.9050601@.deltanet.com...
> I am trying to move my data from Sql Server 65 on Windows NT 4 to my Sql
> Server 7.0 on W2K and can only seem to move the tables, but not the
> objects (such as stored procedures) using DTS.
>
> Is there a way to easily move/transform the whole database from 65 to 7?
>
> Thanks,
>
> Tom.|||On the SQL Server 2000 machine, the program group is called "Microsoft SQL Server - Switch".
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Thomas Scheiderich" <tfs@.deltanet.com> wrote in message news:3FC45F9D.5030901@.deltanet.com...
>
> Tibor Karaszi wrote:
> > Only DTS type which includes other stuff than tables is the Object Transfer. And that is not
> > available when you go from 6.5 (as I remember). You can scrip the stuff to move proc's etc over,
or
> > use the Upgrade Wizard which comes with SQL7.
> >
> >
>
> Where would I find the Upgrage wizard?
> Thanks,
> Tom.
>
> "Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
> news:3FC3F4AB.9050601@.deltanet.com...
> > I am trying to move my data from Sql Server 65 on Windows NT 4 to my Sql
> > Server 7.0 on W2K and can only seem to move the tables, but not the
> > objects (such as stored procedures) using DTS.
> >
> > Is there a way to easily move/transform the whole database from 65 to 7?
> >
> > Thanks,
> >
> > Tom.
>sql