Programming

Well I am new to Unix, I small doubt to clarify with our colloquies here.

Does Unix any of the versions contains its own database or it stores data on the file system.


How to migrate data in Unix to Oracle Data base is there any tool or utility available on Unix that helps to do this activity .

I don't exactly understand your questions, but I'll give this a shot.

I seem to remember that some old versions of BSD did come with a simple version of ingress which was a relational data base. But then ingress became a product. The old free version of ingress could not complete with any current RDB product.

All versions of unix store data in a filesystem, but I have to believe that you already knew that. I'm not a super RDB expert, but every RDB that I know strongly prefers to store the database on a raw disk section thus bypassing the filesystem. They all support putting the database in the filesystem, but advise against this.

The all seem to have "import" utilities that can bring in data from properly formatted unix files. The import ulitity will come with the database package. Of course, some standrard unix commands may be helpful as you reformat your data to make it work with the import utility.

I believe I am in a similar situation.

I have a customer who has some data stuck in an SCO Unix system and wants to get the data out onto a W2000 box. There's no access to cmd lines as it's a turnkey system so we're a bit stuck.

By asking for a backup to diskette from the menu system, we have established that there are some files something.dt and something.nx, (presumably data and index files) possibly others. It fills up the diskette so it's little use.

The vendor is not forthcoming and the only reference I can find to this sort of file is on a 3-com web page on Accessbuilder Name Server.

It's possibly a Novell database but there's little info about it.

A Unix sysadm I know said all this rings a bell but he has no access to manuals etc.

Any help welcome.

You need to embed SQL into a script or a C ( Pro*C) program to move data from unix to Oracle.

I have been researching the possibility of having a data driven dynamic web site and have encountered some information that might be helpful to you.

The website of www.perl.com has information on DBI (Database Interface) and DBD (Database Drivers), which is perl's version of 'ODBC' and the drivers necessary to talk to databases outside of 'unix'. It talks about what you need to put in your 'scripts', etc.... Search on DBI and a whole list of information on it comes up.

It does require loading some free perl modules, drivers as well as a database server daemon (from MySQL- suggested) onto the unix server so that you can use the perl DBI in a script similiar to how you use ODBC to connect to an Access database and SQL to get the data from it for inserting, deleting, etc....

I hope this assists you in some way. At this point for my company, I will be requesting if I can put a partition on my PC for 'Linux' and downloading of all these items to 'test' it out. But after reading your request, I thought using it in the reverse would be of help to you in achieving your project, which is the reverse of mine. Right now we don't have any 'data' on the unix web server, but would like to eventually.


If you have any suggestions on how to get my website data-driven and dynamic just using 'unix' please pass that information my way. So far, it looks like the 'ingress' mentioned in a previous reply is out. What's left?

Thanks,
wme9