List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:February 22 2007 1:41pm
Subject:Re: Duplicating contents of DB within same DB with different prefix
View as plain text  
Hi,

> I revert to this mailing list to ask for help accomplishing a specific
task.
> I'll try to explain as best I can.
>
> Say I have a DB named... well... "database1", this db has the following
> tables:
>
> pt_table1
> pt_table2
> pt_table3
>
> What I want to do is copy each of the tables (exactly as they are,
including
> primary keys, data, etc) but at the same time change the prefix to
something
> else (ie: eng_) so that I would end up with:
>
> pt_table1
> pt_table2
> pt_table3
> en_table1 (exact copy of pt_table1, including data PK, FK, etc..)
> en_table2 (exact copy of pt_table2, including data PK, FK, etc..)
> en_table3 (exact copy of pt_table3, including data PK, FK, etc..)
>
> Anyway of accomplishing this? Ideally without having to state each of the
> tables names. And also that this would work so that you could only
duplicate
> tables that have a certain prefix, so: duplicate only tables that start
with
> "pt_" and change prefix to "es_" for example.
>
> Any help or point in the right direction will be much apreciated!

It seems you're trying to create something multi-lingual, would that
be correct?

If so, why not design proper metadata so you don't have to copy
tables AND modify your queries.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

Thread
Duplicating contents of DB within same DB with different prefixIstvan Hubay Cebrian22 Feb
  • Re: Duplicating contents of DB within same DB with different prefixChris McKeever22 Feb
    • Re: [Fwd: search issue] Duplicating contents of DB within same DBwith different prefixIstvan Hubay Cebrian22 Feb
  • Re: Duplicating contents of DB within same DB with different prefixMartijn Tonies22 Feb
    • Re: [Fwd: search issue] Duplicating contents of DB within same DBwith different prefixIstvan Hubay Cebrian22 Feb
  • Re: [Fwd: search issue] Duplicating contents of DB within same DB with different prefixMartijn Tonies22 Feb
    • Re: [Fwd: search issue] Duplicating contents of DB within same DBwith different prefixIstvan Hubay Cebrian22 Feb
  • Re: Duplicating contents of DB within same DB with different prefixMichael Dykman22 Feb
  • Re: [Fwd: search issue] Duplicating contents of DB within same DBwith different prefixIstvan Hubay Cebrian22 Feb