I would be greatful if any one can help with the
following:

I would like to move large SQL tables (10 million rows)
containing blob data to another SQL server located on a
separtate network. Is there a native SQL format I can use
rather than exporting to dbf,paradox etc.

I would like to create the equivalent of an Oracle dump
file.

A quick and easy way would be

1. Move the tables locally to another Helper DB
2. Back it up
3. Restore at the other server
4. Move the rows using TSQL.

You can do this by cutting the backup to CD.



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"mohammed" <anonymous (AT) discussions (DOT) microsoft.com> wrote