[ic] Sybase Question

Joseph Washco jwashco@hotmail.com
Fri, 16 Mar 2001 22:33:30

Hi All,
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?

Joe Washco

Get your FREE download of MSN Explorer at http://explorer.msn.com