Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

import database schema & data sql files with pgAdmin

Posted on 2010-09-13
6
Medium Priority
?
3,014 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 61

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 61

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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

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 61

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 61

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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
The title says it all. Writing any type of PHP Application or API code that provides high throughput, while under a heavy load, seems to be an arcane art form (Black Magic). This article aims to provide some general guidelines for producing this typ…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
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. …

578 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