Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

import database schema & data sql files with pgAdmin

Posted on 2010-09-13
6
Medium Priority
?
2,946 Views
Last Modified: 2012-05-10
Hi-   I'm wondering how to import database schema & data with pgAdmin?  Right now I'm just using the sample sakila database, http://downloads.mysql.com/docs/sakila-db.zip.  Is there a way to do it without the sql command line?  

thanks!
-xana
0
Comment
Question by:xanabobana
  • 4
  • 2
6 Comments
 

Author Comment

by:xanabobana
ID: 33674038
ok, so I found there's a Data Migration tool but I can't get the installer to download!   http://www.sqlmaestro.com/products/postgresql/datawizard/download/

C:\Documents and Settings\Administrator\My Documents\Downloads\postgresql_datawizard_setup.exe. could not be saved, because the source file could not be read.

I've tried 5 or 6 times since midnight last night with no luck.  Tried emailing them but no luck yet...
0
 
LVL 60

Expert Comment

by:Kevin Cross
ID: 33674452
Which database environment are you using, PostgreSQL or MySQL?  In the question you are trying the MySQL db, but the tool download is PostgreSQL?
0
 
LVL 60

Expert Comment

by:Kevin Cross
ID: 33674463
And I see you are using pgAdmin, so this must be PostgreSQL, right?  So are you trying to import MySQL database to your PostgreSQL server?
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 

Accepted Solution

by:
xanabobana earned 0 total points
ID: 33674883
I finally got the data migration wizard installed!

just in case other people need explicit instructions:

I found & ran the StackBuilder application, which is included in the postgres server install.  I was able to install the data migration tool from there.  Trying it out now, I'll let you know if I get it working!
0
 
LVL 60

Expert Comment

by:Kevin Cross
ID: 33674981
Good luck. So guess you are trying to migrate a MySQL server to PostgreSQL. Got you now on the mix of zones and information.
0
 
LVL 60

Expert Comment

by:Kevin Cross
ID: 33674987
If it does work, you can accept your last comment above as the answer which will (1) refund your points but (2) leave your solution available to the community.  Nice work!
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Suggested Courses

926 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