Ok basically this is the situation. I have my site running on an Access databse and it has a whole bunch of posts on it. Im affraid that if I switch over to SQL i'll lose all those posts. One person told me that ill need to write a script to convert everything properly. How do I go about doing this? I have alot of active users on the site like more than 30 at a time, and access just isnt doing it. I need to make the transition fast. It needs to be done today. SQL Server is working properly, no problems, I just need to convert.
Also I am a newbie, I have no idea how to do this with SQL, or what DTS is (ive been looking through other posts).. Detailed steps would be really great. NeilQuest Hosting Service: http://www.NeilQuest.com
it will contain DTS. In my opinion you really need to shut down the forums when you do this. The reason is that someone my post a topic, but that table has allready been transfered so they will loose the post. Here is some simple steps on what you need to do..
Run setup.asp on your sql server to create the tables needed. Then open up DTS and transfer the data from the access DB to the SQL Server. If DTS creates any new tables then the ID field will not be set so you will need to open up Enterprise Manager to fix the ID fields. This is why you run setup.asp so it will create all the tables for the forums and the other necessary info that DTS will not transfer over.
Topic Locked
Posted - 06 August 2002 : 16:13:37
