how to download an MS SQL database from netsol hosting service to add additional tables?

John90631
John90631 used Ask the Experts™
on
I have an MS SQL database hosted by netsol.com
I need to download the database to add additional tables.
I am using  Microsoft Visual Web Developer 2010 Express
netsol.com supports MS SQL 2005

I had the minimum knowledge to create and upload the original MS SQL database now I cant seem to find the actual database that exists in netsol.com hosting facility and no instructions on how to download it, modify and upload the new version.

Any help would be highly appreciated.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
QPR

Commented:
You don't.... you connect to the database and create new tables either through a UI or by running t-sql statements.
Netsol will need to tell you how to connect.

If you can't connect directly then you will need a backup (*.bak) of your sql database that you can attach locally and create new tables, then upload the Db in the same way you originally did. Will you suffer data loss while you work on a new version locally?

Author

Commented:
QPR
I am only planning on somehow adding new data not deleting any records or tables. Is this what you mean by your question whether I will suffer any data loss while working on a new version locally? A lot of data already exists just need to add more tables...
QPR

Commented:
No, I meant if you plan to add tables to a *copy* of your database and then re-upload it, what will happen to any data that has been added/changed/deleted in the live version of the database?

You d/l the DB and work locally on it to add tables.
John goes to your site and does something that changes data
You upload the latest version of the Db which overwrites the one that is there
Johns visit and associated data is gone forever
Acronis in Gartner 2019 MQ for datacenter backup

It is an honor to be featured in Gartner 2019 Magic Quadrant for Datacenter Backup and Recovery Solutions. Gartner’s MQ sets a high standard and earning a place on their grid is a great affirmation that Acronis is delivering on our mission to protect all data, apps, and systems.

QPR

Commented:

Author

Commented:
QPR
Actually there is NO posibility that this would happen since I intend to be sure that the website is not available to anyone else while I go through the modification process. The database would be unaccessible until the new tables are in place and had been tested.
QPR

Commented:
ok check out the url i posted, the screenshots seem to indicate that you can do "stuff" to your Db by following the links at netsol

Author

Commented:
QPR
yes this link
 http://www.networksolutions.com/support/how-to-add-set-up-an-ms-sql-database-windows-only/
does describe the initial process I went through to add my original DB but doesnt clarify what newbies like me would do to add an additional table - years later :)
QPR

Commented:
I don't have access to that environment so would be able to look.
Normally you have 2 options use a user interface to "add tables" or run t-sql statements in a query window.

You might have to contact netsol or maybe they have a users forum or FAQs to find out which is the correct way in netsol hosting

Author

Commented:
QPR
I appreciate you taking the time to comment on this problem I'm having. I did send out a couple of emails to netsol an hour ago. I'll see what they suggest. I'll award points probably on Monday.
Thanks Q !

Author

Commented:
QPR
 I got the same responses from netsol.com as you.
So i'll follow-up and keep learning !

Thanks
Q

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial