Database Discussion - import/export databases

Print Page | Close Window

import/export databases

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=29165
Printed Date: 28 March 2026 at 9:25am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: import/export databases

Posted By: michael999
Subject: import/export databases
Date Posted: 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

Replies:

Posted By: 123Simples
Date 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

-------------
http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design

Posted By: IanSmithISA
Date 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

http://www.webwiz.net/kb/web-hosting/connecting-to-sql-server.htm" rel="nofollow - http://www.webwiz.net/kb/web-hosting/connecting-to-sql-server.htm

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

-------------
Why does anyone need more than an 80x25 character only VDU?

Posted By: WebWiz-Bruce
Date 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.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting