SQL Server Forums - How to publish database from local to hosting ?

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

Register Now and get your question answered!

Username:	Password:
Save Password
Forgot your Password?

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

How to publish database from local to hosting ?

New Topic

Reply to Topic

Printer Friendly

Author

Topic

asp__developer
Yak Posting Veteran

74 Posts

Posted - 01/09/2013 : 23:52:34

I have a database on my local computer (using SQL Server 2012 express management studio).

How to publish this database to my hosting server ? I am using EXPRESS version so I don't see publish option ?

Any way to accomplish this ?

visakh16
Very Important crosS Applying yaK Herder

India
47960 Posts

Posted - 01/10/2013 : 00:16:28

Does hosting server have sql server installed? if yes, you could just backup database from local and restore it to hosting server

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

asp__developer
Yak Posting Veteran

74 Posts

Posted - 01/10/2013 : 08:58:24

I don't have access to hosting server because it is with hosting company - I only have login credentials for connecting to the server. its like if you have a website with godaddy, you don't have access to server..

plz help

visakh16
Very Important crosS Applying yaK Herder

India
47960 Posts

Posted - 01/10/2013 : 23:12:10

then try scripting out db from local server, connect to hosted server and execute it

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

SQL Server Forums

This page was generated in 0.03 seconds.