how to download an MS SQL database from netsol hosting service to add additional tables?
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.
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.
ASKER
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...
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...
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
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
I know nothing about netsol but this page seems to help
http://www.networksolutions.com/support/how-to-add-set-up-an-ms-sql-database-windows-only/
http://www.networksolutions.com/support/how-to-add-set-up-an-ms-sql-database-windows-only/
ASKER
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.
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.
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
ASKER
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 :)
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 :)
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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 !
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 !
ASKER
QPR
I got the same responses from netsol.com as you.
So i'll follow-up and keep learning !
Thanks
Q
I got the same responses from netsol.com as you.
So i'll follow-up and keep learning !
Thanks
Q
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?