While Microsoft SQL Server may be a robust, powerful SQL database server it sure is hard to work with! :evil: I spent over an hour just trying to move my Mad Dog Portal (v2.5) setup from win5 to win1 on the new cluster. I am lucky there are only a few tables and stored procedures in this app. Even then, I had to try many different methods before finding one that would work.
I don't know a lot about MySQL but I somehow can't help but feel that it would have been much easier in MySQL.
Although, if there were a way to do a backup and restore it would have made life easier. But JodoHost doesn't provide that capability for the end user. So I had to try scripting and exports and all sorts of stuff. I did finally get it done, but I know a little about MSSQL and pitty the poor guy who knows nothing abot SQL trying to do that sort of job.
I know MSSQL database maintenance has been the topic of many other threads, but if anyone has any recommendations on how to backup and manage the MSSQL server on JodoHost please let us know.
FYI, I found this free ASP application that seems to work very well. http://www.1clickdb.com/ I did not use it yesterday for my database move so I don't think it will help much in that area. I just played with it a little and it seems like a really powerful tool. It works with all sorts of databases. Maybe JodoHost would consider buying the real version and making it available to the users?
I don't know a lot about MySQL but I somehow can't help but feel that it would have been much easier in MySQL.
Although, if there were a way to do a backup and restore it would have made life easier. But JodoHost doesn't provide that capability for the end user. So I had to try scripting and exports and all sorts of stuff. I did finally get it done, but I know a little about MSSQL and pitty the poor guy who knows nothing abot SQL trying to do that sort of job.
I know MSSQL database maintenance has been the topic of many other threads, but if anyone has any recommendations on how to backup and manage the MSSQL server on JodoHost please let us know.
FYI, I found this free ASP application that seems to work very well. http://www.1clickdb.com/ I did not use it yesterday for my database move so I don't think it will help much in that area. I just played with it a little and it seems like a really powerful tool. It works with all sorts of databases. Maybe JodoHost would consider buying the real version and making it available to the users?