[ic] Sybase Question
Fri, 16 Mar 2001 22:33:30
I have just installed the demo store "construct something" on my Linux box.
Currently the store is running off of the txt file database that came with
the store. I want to change the database to Sybase for the backend of the
store. So far this is what I plan to do:
1) I have the dsn (or dbi) set up to see Sybase. If I go into the
Administration -> Info page. In the Database Information Area I can see
Sybase listed at one of the available drivers.
2) Looking through the interchange/catalogs/construct/dbconf/oracle folder i
can see the .ora files. I was going to modify these to import the database
structure into Sybase. After the structure was created then i was going to
bring in the txt files from interchange/catalogs/construct/products to
create the stores data again.
Is there an easier way to do this????
3) Change Interchange to look away from the text file and at Sybase. In the
DB documentation, there was a reference to a file called product.sql in
interchange/catalogs/construct/products folder to stop it from using the
text file. How does this file get in here and what does it contain?? Is this
file only created at the time I configured the store?? Do I have to recreate
the store to get interchange to use Sybase?? I also noticed some other info
in regard to the DBs in the admin tool? Do I need to modify any of these?
Get your FREE download of MSN Explorer at http://explorer.msn.com