Export sql server 2000 database as .sql format

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184393 More actions · Answer 1

Do you want to save the schema defintions (Create Table etc...) or the schema and the data?

Steve Jones - SSC Editor SSC Guru Points: 734469 More actions · Answer 2

SQL Server doesn't export the entire database. You can

- back it up, if you need to transfer it somewhere.

- script out the schema (object definitions, permissions, keys, etc)

- export the data in CSV or similar format.

You need to let us know what you are trying to achieve, not just reference Oracle.