Hi all, I'm currently hosting my Snitz Forums on my server at home. I don't want to maintain the server any longer, so I need to move my database to my new hosting provider. How do I go about making the migration? I'll be moving from SQL Server 7.0 to SQL Server 2000. I'm assuming I'll have to use DTS to do this. I guess my questions are these:
1) Should I upgrade the forums on my current server to the latest version 1st? 2) Should I install the forums on my new provider and just leave the database blank and then import all the data using DTS?
I don't want to lose any postings, and I basically want the forums to look exactly like they do now.
If anyone has any experience doing this, I'd certainly appreciate any help you can provide.
I would not upgrade the code and change servers at the same time. Give a few days inbetween or if you have problems you'll have a hard time figuring if it's a db or code problem :)
I have transferred a number of DB's with other code, but haven't transferred a Snitz DB in a long time, but using DTS should work OK. Transfer objects & data, don't just copy tables. Transfer all database objects. I usually don't transfer security, unless you're sure you have the same logins on the target server.
Topic Locked
Posted - 23 December 2004 : 14:28:54
