SQL Assistance Needed

Hello again All.

My efforts to migrate the gallery from one software to another have been fruitless. I have a module for this software (Drupal) that is supposed to do it, but it doesn't work, and I can't get any support from the developer.

So, I'm hoping there are one or more SQL experts out there who may be able to help. I have some experience in SQL, but not enough, I think, to do more than make a mess of things.

What we're looking at are two separate MySQL databases with multiple tables. I need to export the data from one set of tables in one db and import them to the new db with a different sent of tables. So I'll need to create all the necessary fields on this side, which shouldn't be too much of a problem.

If you're interested, please send me a private message. I will provide any detail you might need at that time.

 

Thekidrio (not verified)
Do you have direct access to

Do you have direct access to the dbs? If so what platform? MySQL? Or postgres? Etc. They all have an export function which exports the data and the schema... Send me email if you want.

Steel Rat
Steel Rat's picture
Offline
Last seen: 2 weeks 1 day ago
Joined: 09/28/2015 - 21:43
Yes I have full access to all

Yes I have full access to all the dbs. I can export to mhy heart's content. What I have trouble with is taking data from one set of relational tables, and import the fields I need into another set of relational tables. Some data conversion may also be required, I'm just not sure.

It's what I do... ;) Well, a

It's what I do... ;) Well, a lot of the time. Data-driven software development for web, windows, WPF, etc.

Drop me a line and I'll try to help with what you need.

Sean~ 

Adelea (not verified)
It might be easiest to create

It might be easiest to create the tables on the original DB, then export those and import to the new DB.

create newtablename as 

select oldfield1name as newfield1name,

oldfield2name as newfield2name

...

oldfieldXname as newfieldXname

from oldtablename

 

drlloyd11 (not verified)
I have a few..decades.. of

I have a few..decades.. of SQL experience.  Let me know whats up?

Aielman (not verified)
I have pretty extensive sql

I have pretty extensive sql experience as well as some back ground in manipulating data.  I see that the gallery is still out of sorts, so if you need help let me know and maybe I can help you get back up on your feet as this site is awesome when its up and working fully :-)

Steel Rat
Steel Rat's picture
Offline
Last seen: 2 weeks 1 day ago
Joined: 09/28/2015 - 21:43
Thanks for the replies folks.

Thanks for the replies folks.

I've gotten a couple in private messages. Will see how the latest one pans out, and may tap into your expertise if needed.

Add new comment