Re: Change connection (IP, or Databasename)

hi again,
I do so, but exact the relinking of the database is the problem.

I the new result of the frontend is ready for using in production
environment, I always have to relink / reconnect the frontend to the
"on air" database.
In my frontend I use the tables without the header "public_" witch
is provided from the server. I now have to relink all the tables and
after that I have to rename the tables (erase the "public_"). This takes a
long time (lot's of tables :-) ), isn't there a shorter method ?

thanks

-----Ursprungliche Nachricht-----
Von: Jeff Eckermann [mailto:jeff_eckermann(at)yahoo(dot)com]
Gesendet: Donnerstag, 4. September 2003 22:41
An: edv(at)rdg-rational(dot)de; pgsql-odbc(at)postgresql(dot)org
Betreff: Re: [ODBC] Change connection (IP, or Databasename)

Not sure what you are asking... If you want to create
a copy of your production database for
development/testing purposes, the easiest way is:

CREATE DATABASE myseconddatabase WITH TEMPLATE
myfirstdatabase;

Then just create a new DSN pointing to the new
database (or change your code, if you are not using a
DSN). You would need to relink your tables also.

--- "E. Zorn (RDG-rational)" <edv(at)rdg-rational(dot)de>
wrote:
> hi,
> I am using Access as a front-end for postgresql via
> ODBC.
>
> The postgresql-server is hosted on a separate
> linux-computer.
>
> I like to change the database on the SQL-server for
> developing or
> change the IP of the connected SQL-server so that
> the original data wouldnt
> be changed.
>
> Does anybody know a quick and comfortable way to do
> this. I know the
> possibility of importing the whole tables once again
> but they all have a
> header like "public_" which I have than manually to
> change.
>
> Elmar Zorn
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com