Knowledgebase
Home » Item #465
SQL script creates database but I get page errors / SQL database is blank
Question
I've used the script download from the CactuShop web site to create the SQL database. However the site gives page errors. I have checked that the connection string is correct and that I have set the cursortype setting correctly.
Answer
The problem is that the MS SQL script only creates the table structure, not the data within it. MS SQL does not have a full scripting feature to script data as well as structure.
CactuShop needs certain records to run, i.e. config settings, languagestrings, tax rates, countries, etc. Without these, the store will not work.
Fortunately, it is a simple process to import the contents of the Access DB into the new SQL database using the 'import' feature from within Enterprise Manager.
If you would rather upsize the Access DB using MS SQL Server's "Upsizing Wizard", be sure to read this KB article too:
www.cactushop.com/support/viewitem.asp?recor=0&ID=423