Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

How to import records into a GoDaddy database

Posted on 2009-07-10
6
Medium Priority
?
586 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 31

Assisted Solution

by:RiteshShah
RiteshShah earned 480 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
Understanding Web Applications

Without even knowing it, most of us are using web applications on a daily basis. Gmail and Yahoo email, Twitter, Facebook, and eBay are used by most of us daily—and they are web applications. We often confuse these web applications tools for websites.  So, what is the difference?

 
LVL 44

Assisted Solution

by:GRayL
GRayL earned 480 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 840 total points
ID: 24832309
0
 

Author Closing Comment

by:BBRRGG
ID: 31602319
Thanks!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

610 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