Solved

How to import records into a GoDaddy database

Posted on 2009-07-10
6
578 Views
Last Modified: 2012-05-07
I have tables set up on GoDaddy (someone else set them up for me.)  How can I delete all the records in the table and then add new ones? (the database has changed since the tables were created).  I suppose I have to use the GoDaddy database mgmt tool to do so?

I'll maintain all the existing fields, just need to delete and then add records.  I'm new to GoDaddy, and I know some SQL but not a ton.  Currently my data is in MS SQL Server, though if I can import into GoDaddy directly from Excel or Access, that would be even better, as my experience with SQL Server is not extensive.  

I'd appreciate step-by-step instructions.  Thanks!
0
Comment
Question by:BBRRGG
6 Comments
 
LVL 31

Assisted Solution

by:RiteshShah
RiteshShah earned 120 total points
ID: 24828567
Well, you can use the tool provided by GoDaddy if any or/else you can have your SQL Server database credential like its URL/IP, ID, Password.

login to it by your own sql server management studio (SSMS) and access that table.

BTW, what is the version of that database?
0
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24828568
>>BTW, what is the version of that database?<<

I mean what is the version of SQL Server,??? is it 2000 or 2005?
0
 

Author Comment

by:BBRRGG
ID: 24829321
Thanks for the response.  I'm using 2005.  Can you specify what you mean by "the tool provided by GoDaddy" ?  My understanding is that you cannot upload and then restore a db in GoDaddy due to security.  So the data has to be entered into the system via transactions?  Is that correct??
0
Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

 
LVL 44

Assisted Solution

by:GRayL
GRayL earned 120 total points
ID: 24830847
Have you tried Google - GoDaddy database  ??  there seemed to be several hits about your question.
0
 
LVL 6

Accepted Solution

by:
Yadtrt earned 210 total points
ID: 24832309
0
 

Author Closing Comment

by:BBRRGG
ID: 31602319
Thanks!
0

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Boost your ability to deliver ambitious and competitive web apps by choosing the right JavaScript framework to best suit your project’s needs.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Any person in technology especially those working for big companies should at least know about the basics of web accessibility. Believe it or not there are even laws in place that require businesses to provide such means for the disabled and aging p…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now