Old Forums
Search:
Installation and deployment Questions on installation, system configuration and deployment to the live server.
Version 5.x > Installation and deployment > Export Database View modes: 
User avatar
Member
Member
clive-innovativedesign.gb - 5/14/2010 12:54:46 AM
   
Export Database
Hi,

I'm moving my site from my local testing server to the live server.

I get permission errors trying to import my site files, also get errors trying the "Shared Hosting Environment and Medium Trust Level" way. So I thought I would try the

"classic backup/restore approach" way, but I can't seem to export my database data to a .SQL file.

I'm runing:
SQL Server 2005 with SQL Server Managment Studio Express

Anyone know how I do this?

Many thanks

Clive

User avatar
Kentico Developer
Kentico Developer
kentico_martind - 5/14/2010 3:46:49 AM
   
RE:Export Database
Hi Clive,

I would recommend using standard backup functionality that exports file into .bak file. Please see http://msdn.microsoft.com/en-us/library/ms187510.aspx and http://msdn.microsoft.com/en-us/library/ms177429.aspx for more details.

Best Regards,

Martin Dobsicek

User avatar
Member
Member
clive-innovativedesign.gb - 5/14/2010 8:22:14 AM
   
RE:Export Database
Thanks for your reply.

But how do I import a .bak file when the database on the live server is asking for a .SQL file?

Many thanks

Clive

User avatar
Kentico Developer
Kentico Developer
kentico_martind - 5/17/2010 3:56:40 PM
   
RE:Export Database
Hi Clive,

The procedure described at http://msdn.microsoft.com/en-us/library/ms177429.aspx should accept the .bak file. Could you please use this procedure?

Best Regards,

Martin Dobsicek

Top