Save a database including all data to a SQL text file

[Paul Johnson]

Does anyone know how to back up everything from a sql 2000 db to one SQL
text file. I'm dealing with a rubish host Nildram and that is the only
way to upload a database. I know how to save a database schema, sp,
views and so on usings "Generate SQL Script" in enterprise manager but
that dosnt seem to be able to store the actual table data in it.

 

[William \(Bill\) Vaughn]

Is there an ODBC or OLE DB driver for the database (or better yet a .NET
provider)?
If so you can use DTC or BCP to move the data.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

 

[Paul Johnson]

Is there an ODBC or OLE DB driver for the database (or better yet a .NET
provider)?
If so you can use DTC or BCP to move the data.

The website is able to directly connect to the sql server. However, to
upload the database from the office local copy the only way to do that
is via a web based interface that will only take sql text files.

 

[Uri Dor]

I use a product called DBGhost from Innovartis that can do that (and
other stuff).
BTW, I've had problems with "Generate SQL Script" regarding the way it
orders CREATE VIEW statements for dependant views. DBGHost gets it right.

 

[Paul Johnson]

Ahh thanks i'll take a look at this program.
I too have had problems in the past with the order of tables too. Oh
well lets hope they get it all right in sql server 2005