I was using Access, but now I have over 50,000 posts and it's getting EXTREMELY slow. So I want to move to SQL Server. Is this an easy task? Anyone have any tips?
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).
If you could I would have said so. I have no particular pleasure in writing long posts and advising people to apply a complex solution if there is a simpler one available.
quote: If you could I would have said so. I have no particular pleasure in writing long posts and advising people to apply a complex solution if there is a simpler one available.
So did you copyright this answer or can I use sometimes it too? It's perfect! That made my day!
SQLTeam.com - For SQL Server Developers and Administrators Snitz Info - SQL Server info on Snitz Forums
Topic Locked
Posted - 15 July 2002 : 21:27:18
.