One can export the data fairly easy by using a utility called BCP (bulk copy) called in a script that iterates thrhough the system tables to get all table names and use each name as parameter. In V.2000 is much easier to get the list of tables name from a database.
If it is data schema to be dumped as a script the mechanism is the same in V.2000 as in V6.5. Why would you want to this is another story. None of these are suitable for porting the database to another RDBMS. Not even to re-create the same database to another installation of MSSQL. Nor are they suitable for documenting the schema. On Mon, 2006-03-20 at 21:33 +1200, Don Gould wrote: > On Mon, 2006-03-20 at 21:28, Zane Gilmore wrote: > > Don Gould wrote: > > > It's not that hard to get data out of mssql really is it? > > That wasn't my point. It's a databse of course one can get data out of it. > > My point was that you can't easily dump a MS-SQL database into SQL > > script form. > > MS only provides the means of dumping to some unreadable file format > > that only MS-SQL can read. Hence enhancing their lock-in. AFAICS > > > Ok, I'm confused... > > In version 6.5 it was easy enough to just dump a script. > > Fairly dumb I agree, if you can't can't do that in the current versions. > > Oh well.... not to worry, just another reason to use FLOSS :) > > Cheers Don > > >
