 |
|
Windows Web Hosting 30 Day Free TrialWindows Hosting 30 Day Free Trial, with no obligation, on all our Windows Web and Reseller Hosting Packages.For more information see our Windows Hosting 30 Day Free Trial page. |
import/export databases |
Post Reply 
|
| Author | |
michael999 
Newbie 
Joined: 04 March 2011 Status: Offline Points: 2 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: import/export databasesPosted: 04 March 2011 at 11:12am |
|
I am trying to use ms sqlserver management studio express.
I cannot see the options for importing or exporting databases online. I think that I should also be able to connect to my online databases but cannot see how to do that either.
Judging from other comments and discussions these features are well hidden!!! michael
|
|
 |
|
|
MrTWS
Senior Member 
Joined: 08 July 2007 Location: United Kingdom Status: Offline Points: 1192 |
Post Options
Thanks(0)
Quote Reply
Posted: 04 March 2011 at 12:44pm |
|
Hi Michael
I tried using the software myself sometime back - it is fairly complex. I believe you would need all the connection details required to connect to your database in this way. If however you are using web wiz, you should be able to import/export through your Website Panel when you have logged in |
|
|
|
|
IanSmithISA
Newbie
Joined: 21 October 2010 Location: Worcester Status: Offline Points: 20 |
Post Options
Thanks(0)
Quote Reply
Posted: 04 March 2011 at 1:04pm |
|
Good morning
I don't know if you can do a restore, but to get up to point where you can try whilst waiting for someone who knows more than me.
1) First create a database with the desired name via the WebWiz control panel
2) Connect to the WebWiz Server from the management console, you will need to use SQL Server Authentication, see
to get the server name.
3) Right Click on Databases in the Object Explorer and select the relevent option.
However I have never gone beyond this, so you may get a permission denied.
Bye
Ian
|
|
|
|
|
WebWiz-Bruce
Admin Group 
Web Wiz Developer Joined: 03 September 2001 Location: Poole, England Status: Offline Points: 8028 |
Post Options
Thanks(0)
Quote Reply
Posted: 04 March 2011 at 5:33pm |
|
If you are hosting with ourselves here at Web Wiz then in your WebsitePanel Control Panel go to the SQL Server page and next to the name of the database you will see a 'Database Tools' link.
This 'Database Tools' link will take you to an online tool that can be used for uploading and downloading database backups. To restore a SQL Server database first create a backup then use the Restore Tool to upload the database and restore it to our servers.
|
|
|
|
Topic Options|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
