Hello, I am in the process of completing the appropriate tables for a simple crm system. My intention was to find someone to create a vb6 frontend to work with the data. A friend who used to work with SQL said that I should look into the possibility that my free SQL is very limited in what it can accomplish. How can I know that this is the right starting point?
You have had bad advice imo. I doubt it will be limiting for you at all in fact its a perfect way to start an application because you can always upgrade later to SQL 2005 standard when you need more capacity. There are limits on the number of CPU cores and memory that the free versions can address but to be honest unless your app is pretty high usage I doubt you will have a problem. SQL 2008 Express has even higher limits - (2gb in sql 2005 express and 4gb db size in 2008 i believe). You could also use MySQL - which has no real limits and is not that hard to get working with vb6 applications.
Thanks for the good info. If I start out with what I have, i assume that I can always upgrade in the future without having to make my previous software and database work completely worthless. Correct?