Looking at the instructions for access to sql... The first bit do i have to run snitz locally to create to tables in the database? Do i create the database in access and connect to it locally with dsnless connection and then run setup.asp?RC5
1. Create, or have your host create a blank database for you. 2. Run setup.asp?RC=5 to create the Snitz base tables in the database. 3. If you have mods installed, run mod setup for each of your mods, so that the necessary changes and additions are done in the database. 4. Use DTS to transfer the data from your Access database to your SQL Server database. You should make sure that for each table the DTS transform column is configured so that any existing table data is deleted and enable identity insert is checked.
For this last step you'll need to use SQL Server's Enterprise Manager or have someone who does it for you (maybe your host, but make sure the settings I described here are used).
i have started the process in that i've created the sql db and successfully created the tables etc. i have started to transfer the date via EM but I am getting some errors. "copy data from FORUM_CONFIG_NEW, FORUM_GROUP_NAMES FORUM_MEMBERS" so far.
Topic Locked
Posted - 05 October 2005 : 15:26:13
