All-
I am very pleased to announce that I have the entire SQL Server database
duplicated on PostgreSQL, indexed, PKs, FKs, clustered, etc, and it ROCKS!
Not only that, but my 43-line queries all work properly and are lightening
fast! Unless I come across something completely unexpected, I feel
co
Glad to help. Have fun. :-)
-Jon
On Jan 12, 2007, at 4:52 PM, Matt Quackenbush wrote:
> Jon,
>
> Your solution worked just fine actually :-) Thanks again!
>
>
> Matt
>
~|
Create robust enterprise, web RIAs.
Upgrade & integ
Jon,
Your solution worked just fine actually :-) Thanks again!
Matt
~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adob
Truthfully,I've always done it with CF so I don't know what the fully
query would be with postgres.
You can run the following query to get the table names and primary
key names (where they are defined)
select table_name, column_name from
information_schema.constraint_column_usage ;
Then ju
Jon,
Thanks for the reply. Indeed I did miss it. I was hoping to write one long
..sql script and run it from my query editor and update all tables in a
single connection. Are you aware of a way to do that? If not, I'll use
your CF solution :-)
Matt
On 1/12/07, Jon Clausen <[EMAIL PROTECTED
Matt,
I sent in a previous e-mail but you may have missed it:
SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence
('#table#','#table_id#'), (SELECT max(#table_id#) FROM #table#), true);
That way you don't have to provide the sequence name.
HTH,
Jon
On Jan 12, 2007, at 2:41 PM, Matt Qu
I don't know why i wrote the '+1' in there when I wrote the email. I'm not
using it in the actual statement. The specific syntax error is that the (
is invalid.
On 1/12/07, Matt Quackenbush <[EMAIL PROTECTED]> wrote:
>
> Okay, so far I'm *really* liking Pg. I have successfully imported all of
>
Okay, so far I'm *really* liking Pg. I have successfully imported all of my
tables and data, and have everything fixed with one exception: updating the
currval() of the sequence for the 'auto_number' fields. I can go through
each sequence one at a time with the GUI and update it, but I'd obviousl
David Livingston wrote:
> If you just want a single IP to be able to connect the format is
> 555.555.555.555/0 .
> Obviously you replace the 555 stuff with your IP.
It is the other way around. /32 means 1 IP address, /0 means all IP addresses.
The number after the slash is the number of bits in
If you just want a single IP to be able to connect the format is
555.555.555.555/0 .
Obviously you replace the 555 stuff with your IP.
Dave
On Jan 11, 2007, at 4:14 PM, Matt Quackenbush wrote:
> Jochem,
>
> Thank you. That was the problem. I didn't realize that it was
> needed.
> Remote c
Jochem,
Thank you. That was the problem. I didn't realize that it was needed.
Remote connection up and running; time to play! :-)
Matt
On 1/11/07, Jochem van Dieten <[EMAIL PROTECTED]> wrote:
>
> How did you write your IP address? Did you add the /32 to use
> *CIDR-address* notation?
>
> Jo
Matt Quackenbush wrote:
>
> host *database* *user* *CIDR-address* *auth-method* [*auth-option*]
> host *database* *user* *IP-address* *IP-mask* *auth-method*
> [*auth-option*]
> My pg_hba.conf file contains the following lines (below all of the
> instructions):
>
> # TYPEDATABASE
On 1/11/07, Jochem van Dieten <[EMAIL PROTECTED]> wrote:
>
> > LOG: invalid IP mask "password" in file "C:/Program
> > Files/PostgreSQL/8.2/data/pg_hba.conf" line 72: Unknown host
>
> You are missing a column in your pg_hba.conf. Do you have the real one
> somewhere?
>
> Jochem
Which column am
Matt Quackenbush wrote:
>> This is a bad combination because they result in a cleartext communication
>> and even a cleartext password. Best would be to install a certificate and
>> use hostssl instead of host, but at least you should use md5 instead of
>> psssword.
>
> Thank you for the tip on the
Jochem,
This is a bad combination because they result in a cleartext communication
> and even a cleartext password. Best would be to install a certificate and
> use hostssl instead of host, but at least you should use md5 instead of
> psssword.
Thank you for the tip on the ssl/md5/password issue
Matt Quackenbush wrote:
> Hmmm... I setup PostgreSQL on one of my production (remote to me) servers.
> It's all working wonderfully from localhost. To prepare it for allowing
> remote access, I added the following line to the pg_hba.conf file:
>
> hostsameuserall (the IP, e.g. 555.55
Hmmm... I setup PostgreSQL on one of my production (remote to me) servers.
It's all working wonderfully from localhost. To prepare it for allowing
remote access, I added the following line to the pg_hba.conf file:
hostsameuserall (the IP, e.g. 555.555.555.555)password
I then add
Dave Watts wrote:
>> Am I correctly understanding what I'm reading on their site
>> that Aqua Data Studio supports ALL of the listed databases in
>> the same client? (As opposed to having a different one for each DB?)
>
> Sure. It's a JDBC client, just like CF. I doubt it provides GUI managemen
> Am I correctly understanding what I'm reading on their site
> that Aqua Data Studio supports ALL of the listed databases in
> the same client? (As opposed to having a different one for each DB?)
Sure. It's a JDBC client, just like CF. I doubt it provides GUI management
functionality found in
I concur with Jon. I'd use Character Varying.
Dave
On Jan 10, 2007, at 5:31 PM, Jon Clausen wrote:
> No you're right - now days. I've had some issues with older drivers
> where they would throw a syntax error on me so I always use character
> varying with Pg just to be on the safe side.
>
> On
No you're right - now days. I've had some issues with older drivers
where they would throw a syntax error on me so I always use character
varying with Pg just to be on the safe side.
On Jan 10, 2007, at 6:10 PM, Matt Quackenbush wrote:
> Sweet (regarding the single interface)!
>
> Jon, I wa
Sweet (regarding the single interface)!
Jon, I was under the impression that varchar() was still a valid datatype in
Postgre, and would not require changing to 'character varying'.
http://www.postgresql.org/docs/8.2/static/datatype-character.html
Am I mis-reading that?
Dave,
Thanks for the tip
On Jan 10, 2007, at 5:13 PM, Matt Quackenbush wrote:
> Am I correctly understanding what I'm reading on their site that
> Aqua Data
> Studio supports ALL of the listed databases in the same client?
> (As opposed
> to having a different one for each DB?)
Yes. It rocks!
Dave L's instructions
Matt Quackenbush wrote:
> Am I correctly understanding what I'm reading on their site that Aqua Data
> Studio supports ALL of the listed databases in the same client? (As opposed
> to having a different one for each DB?)
>
Yes...it is very nice having the same interface for multiple database
sys
Am I correctly understanding what I'm reading on their site that Aqua Data
Studio supports ALL of the listed databases in the same client? (As opposed
to having a different one for each DB?)
~|
Create robust enterprise, web RIAs
Here is what I have done in the past. Use enterprise manager to
script out the tables to a sql script. Then do a find an replace on
the script to convert the data types and remove all of the MS
specific stuff. Once you have a good generic SQL script run it on
postgres to create all of your
Matt Quackenbush wrote:
> Jim,
>
> Are you referring to v6 RC1? That's all I've seen so far on their site.
>
Yes, I believe that is the latest version...but I think the 4.7 version
also had the export capability I was describing. I went ahead and
started using the RC because I wanted to use
Joshua,
Thanks for the pointer and the link.
Jim,
Are you referring to v6 RC1? That's all I've seen so far on their site.
Thanks,
Matt
On 1/10/07, Jim Wright <[EMAIL PROTECTED]> wrote:
>
> Joshua Cyr wrote:
> > Wasn't Aqua Data Studio free at one point? I swear I didn't buy it...
> but
>
Joshua Cyr wrote:
> Wasn't Aqua Data Studio free at one point? I swear I didn't buy it... but
> could be forgetting. I don't do the warez thing, so either it was
> legitimately free at one point or very inexpensive or I am losing too many
> brain cells on WOW.
>
Prior to the current version 6, i
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 10, 2007 4:17 PM
To: CF-Talk
Subject: Re: Transferring from MS SQL (2000) to PostgreSQL
Joshua Cyr wrote:
> I have used Aqua Data Studio for just that task. (mysql and mssql to
> postgre). I had to do it table by table, but I did it for m
Joshua Cyr wrote:
> I have used Aqua Data Studio for just that task. (mysql and mssql to
> postgre). I had to do it table by table, but I did it for millions of
> records with relative ease. Export to delimited text file or file with
> insert statements, then import to the other db.
>
> http://w
I have used Aqua Data Studio for just that task. (mysql and mssql to
postgre). I had to do it table by table, but I did it for millions of
records with relative ease. Export to delimited text file or file with
insert statements, then import to the other db.
http://www.aquafold.com/
Joshua Cyr
I have found this software, but it appears to be brand new. Has anyone had
any experience with it? Or with something similar that you would recommend?
http://www.download3k.com/Business-Finance/Database-Management/Download-MS-SQL-Server-PostgreSQL-Import-Export-Convert-Software.html
~~
33 matches
Mail list logo