deansatch Posted February 22, 2012 Share Posted February 22, 2012 I have always worked in php on linux servers but I have to transfer someone's windows site to a new host for them. I thought it would be straight forward but now I have the hosting ready with all their files uploaded and have a MS SQL database set up I a) can't figure out where the hell I am supposed to put the new database connection details (php stuff always just has an included config file - simple!) and b) have connected to the MS SQL server with navicat and tried importing the .bak file but it seems to do fuck all! Help!!! CMS they are using is 'Umbraco' btw Link to comment https://forums.phpfreaks.com/topic/257550-first-time-using-ms-sql-usually-mysql-help/ Share on other sites More sharing options...
kicken Posted February 23, 2012 Share Posted February 23, 2012 Never heard of/used that cms. Google seems to indicate it's a .net app though which would lead me to believe the connection details for the db probably go into the Web.config file, likely in the site's root folder. As for the DB, if you have a backup from the old DB you probably just need to use the restore functionality to bring it back on the new server. If you have access to sql management studio it's pretty easy to do from there. Link to comment https://forums.phpfreaks.com/topic/257550-first-time-using-ms-sql-usually-mysql-help/#findComment-1320279 Share on other sites More sharing options...
alvin567 Posted June 3, 2012 Share Posted June 3, 2012 You have to be sure about the version of mssql you are using. I use the wrong version like 2008 and when the server is 2005 and ended up I have to reinstall everything from scratch again. You need to ip address of the host for it to work. Link to comment https://forums.phpfreaks.com/topic/257550-first-time-using-ms-sql-usually-mysql-help/#findComment-1350768 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.