> Hello, if this a one time thing I would use the import export wizard on
the
> SQL 2005 side and migrate that way. If that is not possible you could
script
> the tables and use bcp on both sides one to pull the data out and one to
push
> the into.
>
> there are lots of ways to do this work. If you don't want the SQL 2005
> client on the SQL 2000 then your options are less. you can install just
the
> client with out installing SSMS on the SQL 2000 side if that helps at all.
>
> Hope that helps
>
> John Vandervliet
>
> "wit1" wrote:
>
> > Is there any way to:
> > pull SQL Server 2005 database tables into a SQL Server 2000 database,
> > without installing Management Studio on the SQL 2000 server?
> >
> >
> >
> >

"wit1" wrote:

> Well it is not a 1 time thing,
> is that client (only) install free? if so, where can I download it install
> it on the 2000 server?
> Thanks.
>
> "John Vandervliet" <John Vandervliet@discussions.microsoft.com> wrote in
> message news:3903F9F8-2E24-4B79-B386-423A3747BF71@microsoft.com...
> > Hello, if this a one time thing I would use the import export wizard on
> the
> > SQL 2005 side and migrate that way. If that is not possible you could
> script
> > the tables and use bcp on both sides one to pull the data out and one to
> push
> > the into.
> >
> > there are lots of ways to do this work. If you don't want the SQL 2005
> > client on the SQL 2000 then your options are less. you can install just
> the
> > client with out installing SSMS on the SQL 2000 side if that helps at all.
> >
> > Hope that helps
> >
> > John Vandervliet
> >
> > "wit1" wrote:
> >
> > > Is there any way to:
> > > pull SQL Server 2005 database tables into a SQL Server 2000 database,
> > > without installing Management Studio on the SQL 2000 server?
> > >
> > >
> > >
> > >
>
>