4 Replies - 1755 Views - Last Post: 14 March 2013 - 02:58 AM Rate Topic: -----

#1 pistolizedpete  Icon User is offline

  • D.I.C Head

Reputation: 2
  • View blog
  • Posts: 65
  • Joined: 02-December 08

How to migrate stored procedures between databases (Linux)

Posted 13 March 2013 - 08:23 AM

Hi there,

I'm looking for the simplest way to copy/move stored procs from one database to another.
There seems to be a way to do this on Windows with Management Studio by generating scripts
and running them in the required database but, I need a way to do it using Ubuntu.

Wine doesn't do much to help here...

So is there any native Linux application that can generate scripts for this task?

Thanks a lot.

Is This A Good Question/Topic? 0
  • +

Replies To: How to migrate stored procedures between databases (Linux)

#2 modi123_1  Icon User is offline

  • Suitor #2
  • member icon



Reputation: 9287
  • View blog
  • Posts: 34,811
  • Joined: 12-June 08

Re: How to migrate stored procedures between databases (Linux)

Posted 13 March 2013 - 08:23 AM

... which database is it for?
Was This Post Helpful? 0
  • +
  • -

#3 pistolizedpete  Icon User is offline

  • D.I.C Head

Reputation: 2
  • View blog
  • Posts: 65
  • Joined: 02-December 08

Re: How to migrate stored procedures between databases (Linux)

Posted 13 March 2013 - 08:37 AM

PostgreSQL databases,

I'm currently using SQuirreL SQL to connect to and view them.

Apologies for any lack of information. Databases are very new to me :)

This post has been edited by pistolizedpete: 13 March 2013 - 08:47 AM

Was This Post Helpful? 0
  • +
  • -

#4 modi123_1  Icon User is offline

  • Suitor #2
  • member icon



Reputation: 9287
  • View blog
  • Posts: 34,811
  • Joined: 12-June 08

Re: How to migrate stored procedures between databases (Linux)

Posted 13 March 2013 - 08:46 AM

Well there's plenty of migration tools and scripts when searching "PostgreSQL migration"... example:
https://wiki.postgre...Backup_on_Linux
http://www.howtoforg...inimal-downtime
http://www.enterpris...gration-toolkit
Was This Post Helpful? 0
  • +
  • -

#5 pistolizedpete  Icon User is offline

  • D.I.C Head

Reputation: 2
  • View blog
  • Posts: 65
  • Joined: 02-December 08

Re: How to migrate stored procedures between databases (Linux)

Posted 14 March 2013 - 02:58 AM

Yep there is, but none of which I understand!

Using your third link, I installed Postgres Enterprise Manager as I was hoping for
some graphical application to do this by copying procs to the new database and just editing
their information eg owner etc after copying but there doesnt seem to be a way to do this.

I dont really understand how the Bash scripts work or what they do? It looks to me like they are used to make a backup of a database but I just need to take certain entities from an existing db and place them in a different schema on another existing db.

This post has been edited by pistolizedpete: 14 March 2013 - 03:12 AM

Was This Post Helpful? 0
  • +
  • -

Page 1 of 1