Σ Sigma Hosting is mainly a video tutorial website

Σ Sigma Hosting is mainly a video tutorial website that make it easier for you to search within the transcript of videos for solutions of problems you might face during your journey in dealing with different webhosting companies. So, we are very sorry if the text is not well organized and we may work on it in the future but for now we hope you get the benefit mainly from the video then you may need to have a look on the transcript. Thanks for your understanding 🙂

hello everyone in this video let's see how we can move Microsoft sequel bells database to a third-party hosting server like karate or Hostgator or any of the similar hosting providers to get started let's open ms SQL management studio connected to any of the server that you would like to in this case it's a local database which resides on the system as a sample we have a database named demo and score DB which has couple of tables and a stored procedure okay – first of all what we have to do is we have to export this file and then import that file in into our hosting account to export the file right click on the database go to task backup here you can add the location where you would like to take the backup of this database you can select the location right here and give it a name let's say they move this code D P dot B easy make sure to give extension of V a K okay then click OK then select that particular destination then click OK so V be exported complete we go to that location you can see that file has been created okay now let's go to a hosting account I have a account and monos hosting and it should be pretty much the process should be pretty much the same let's log in there here you should have an option to manage the database and you can go over there and click on add database let's give it a name and please give me and make sure that you select Microsoft sequel as the database server as you are exporting Microsoft sequel based database and then this click OK so we have created the database here now what we need to do is just import the file that we have exported from SQL Server management studio okay click on import term wrong and this is the file that we exported with open click okay may take a while based on the size of the database file that you have okay so the DB input is completed just to cause verifying let's write a simple query years and then aggregate so we have six rows of data in here and three columns and Bridey name and Department let's see if we have same data available effects for importing in or hosting the kernel to test that go to your admin control panel you can verify if you have the important as you can see we have successfully imported our database you can see those two tables and also the store procedure right here okay it also got certified the same thing there you go okay so that can be import my piece of pickle this database in our hosting account and hope this video helped you and thanks for watching .

Video Discription

 

Leave a Reply