Exporting Data into Flat files.

[joseppic]

I need some help how to migrate data from SQLBase ready for it to be imported into SQL Server.

I need to get SQLBase Table data into Excel or CSV files.
Any ideas?

I have SQLTalk, not sure what other tools are available to me.

The Backup of a SQLBase DB - can the file be imported into anything else??


thanks for your time,

Joe.

 

[Tusk]

You could try the UNLOAD DATA SQL filename ALL; command. This will unload all tables of the logged in user including the data into the named file. The output file will consist of INSERT commands followed by data rows. There are no CREATE TABLE or CREATE INDEX statements in the file.

The other option is to use the ASCII parameter but this limits you to a single table unload. Check out the Centura SQLBase language Reference manual available from the Centura website.