Hi All
Working on our new website at work and we have hit a major snag.
We were going use MS Sql server 2005 Workgroup edition, however we have just found out that it doesnt do what we need, turns out we need Standard Edition which is 5k, we simply cant afford this at this time.
If I list what we need to do below, and how I am thinking of doing it could you guys give me some feedback?
We have multiple product feeds from multiple suppliers that are uploaded onto our server as csv feeds via FTP.
These feeds need to be inserted into a table, 1 for each feed, ie feed a > table a etc etc.
These then need to be inserted into a master table, along with a field that lists what feed they came from added to the end.
This table then becomes our master table which feeds the rest of the site.
The issue is automating the procedure. Do you the whole thing could be done in Mysql and PHP with cron jobs?
The next snag is that our site is currently running on asp. Could we use this to work with MYsql, or would it be better to insert the data into an SQL Database, probably MSSql Express Edition
Thanks for any feedback guys, my heads a mess
Aaron
Working on our new website at work and we have hit a major snag.
We were going use MS Sql server 2005 Workgroup edition, however we have just found out that it doesnt do what we need, turns out we need Standard Edition which is 5k, we simply cant afford this at this time.
If I list what we need to do below, and how I am thinking of doing it could you guys give me some feedback?
We have multiple product feeds from multiple suppliers that are uploaded onto our server as csv feeds via FTP.
These feeds need to be inserted into a table, 1 for each feed, ie feed a > table a etc etc.
These then need to be inserted into a master table, along with a field that lists what feed they came from added to the end.
This table then becomes our master table which feeds the rest of the site.
The issue is automating the procedure. Do you the whole thing could be done in Mysql and PHP with cron jobs?
The next snag is that our site is currently running on asp. Could we use this to work with MYsql, or would it be better to insert the data into an SQL Database, probably MSSql Express Edition
Thanks for any feedback guys, my heads a mess
Aaron