E-Commerce and SBT(Accpac) Accounting Package - revisted

similar problem new question

[alphanumerik]

I have been awarded a task probably too big for me to handle but I am the only "computer person" (meaning I understand the fundamentals of turning one on and off) at my store. I need to migrate SBT 5.0i to MS Small Business Manager 7.0

I found this forum doing a google search - apparently someone has addressed a similar issue with SBT - I also will have to make the data available to the web which I figure I will takle when I get that far.

If someone here could direct me to a place where I can teach myself how to get the data from one program to the other I would be really grateful. I know I need vis foxpro because SBT is apparently built on that software - I thought it would be as easy as just finding the DBF files using foxpro and exporting them to MS Excel where i could save them in a format that MS SBM 7.0 could read - but upon browsing the directory of SBT I find that there are hundreds (ok not hundreds but a lot) of .DBF files.

My real question is, Where do I start. Im not asking for somebody to do it for me - I have plenty of time, I just have no idea what im up against and how to approach solving this.

It appears that MSSQL server is what is running on a Win NT machine with a domain if that is of any help?

Any help would be great.

[TallTroll]

Data migration is a pretty specialist discipline. I have worked for a UK accounts software house in a former life, and the company I currently work for uses accounts datafiles on a regular basis too, and I can tell you there are nearly ALWAYS little wrinkles in how data in one table set translates to a different table set (usually annoying little things like mis-matching field types or lengths across tables. Do you have ANY idea how annoying it is to spend a day trying to migrate a table with about 1% null cells into a related field that won't accept null content. DO YOU?!? </foam>)

Anyway, my recomendation would be to get a specialist. Or be prepared for a very frustrating experience