Local copy

Hi,
i have a Sqlserver 2000 database on a webserver. Now i want to move this
database to another provider (server). I have restricted access to the
database. What is the best way to retrieve all the data to a local pc ? What
i need is a sort of Backup to local pc. I have asked the provider to put
this on a cd-rom, but he refuse this.
GL.A quick way is to : create a database on a local server, transfer all
objects/data to the local server copy
Jack Vamvas
________________________________________
__________________________
Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
New article by Jack Vamvas - SQL and Markov Chains -
www.ciquery.com/articles/art_04.asp
"Grard Leclercq" <gerard.leclercq@.pas-de-mail.fr> wrote in message
news:UUNDf.225782$bM3.7399534@.phobos.telenet-ops.be...
> Hi,
> i have a Sqlserver 2000 database on a webserver. Now i want to move this
> database to another provider (server). I have restricted access to the
> database. What is the best way to retrieve all the data to a local pc ?
What
> i need is a sort of Backup to local pc. I have asked the provider to put
> this on a cd-rom, but he refuse this.
> GL.
>|||I know this issue, the same for my provider, the best is (as far as you
don=B4t store blob columns) to script the data out to a script file and
reapply the data to your destination database, This worked fine for me.
See this script here for more information:
http://vyaskn.tripod.com/code.htm#inserts
HTH, Jens Suessmeyer.|||Thank you, finally the provider have ask me 150 euro for a copy on CD. But
the next time i keep your advise in mind.
Thx - GL
"Jens" <Jens@.sqlserver2005.de> schreef in bericht
news:1138733350.602238.280700@.g44g2000cwa.googlegroups.com...
I know this issue, the same for my provider, the best is (as far as you
dont store blob columns) to script the data out to a script file and
reapply the data to your destination database, This worked fine for me.
See this script here for more information:
http://vyaskn.tripod.com/code.htm#inserts
HTH, Jens Suessmeyer.