Greetings.
I am having difficulty moving a SQL Server 2000 database over to
PostgreSQL 8.0.3.
In SQL Server, I am performing a backup of the database I want to move.
I save that backup on my Desktop.
I am then opening up PGAdminIII and attempting to perform a Restore of
the database saved
I am pretty sure a backup from sql is not going to restore on postgres.
I wrote a .net application that read from one and wrote to the other.
Does not like tables large then memory available though, since npgsql .net
components by default uses a read whole table approach (there is a cursor
way, but
[EMAIL PROTECTED] wrote:
Greetings.
I am having difficulty moving a SQL Server 2000 database over to
PostgreSQL 8.0.3.
In SQL Server, I am performing a backup of the database I want to
move. I save that backup on my Desktop.
That backup is in Microsofts own format, PostgreSQL will not be
* Marc G. Fournier ([EMAIL PROTECTED]) wrote:
> Is there a way of REVOKEing privileges on all tables in a database? I've
> checked the REVOKE man page, and there doesn't appear to be, but I figured
> I'd double check to make sure ...
I actually wrote a little perl script which allows you to pas
Only thing you may run into moving data is field types.
I had to convert my bit fields to binary and my datestammp to timestamp.
I would just be sure the field types are supported or you may have to do a
search replace on the text file created by aquastudio.
Although when I used aqua I exported us
Check out WinSql
(http://www.synametrics.com/SynametricsWebApp/WinSQL.jsp) It has the
ability to extract data from Sql*Sucker and drop it into PostGreSql, and
you can have that functionality free for 90 days to boot.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On
It would be great to look at that :)
g
On 8/9/05, Stephen Frost <[EMAIL PROTECTED]> wrote:
* Marc G. Fournier ([EMAIL PROTECTED]) wrote:> Is there a way of REVOKEing privileges on all tables in a database? I've
> checked the REVOKE man page, and there doesn't appear to be, but I figured> I'd
Here's my 2 cents.
If you have access to DTS in SQL Server 2000, it will be one convenient
solution for simple transfer.
It's a matter of creating a new task, defining the SQL Server database as
source and PostgreSQL database as destination, and clicking through. There
will be some mismatches in
On Aug 9, 2005, at 9:20 AM, Stephen Frost wrote:
* Marc G. Fournier ([EMAIL PROTECTED]) wrote:
Is there a way of REVOKEing privileges on all tables in a
database? I've
checked the REVOKE man page, and there doesn't appear to be, but I
figured
I'd double check to make sure ...
I actual
"Salem Berhanu" <[EMAIL PROTECTED]> writes:
> What exactly is the SQL_ASCII encoding in postgres?
SQL_ASCII isn't so much an encoding as the declaration that you don't
care about encodings. That setting simply disables encoding validity
checks and encoding conversions. The server will take any b
Not that I am an expert or anything, but my initial data base was SQLASCII
and I did have to convert it to Unicode.
My reasons were we store French characters in our database and the newer
odbc driver was not displaying them correctly coming from SQLASCII, but was
from UNICODE.
I also think that it
On Tue, Aug 09, 2005 at 12:56:37PM -0400, Joel Fradkin wrote:
> Not that I am an expert or anything, but my initial data base was SQLASCII
> and I did have to convert it to Unicode.
> My reasons were we store French characters in our database and the newer
> odbc driver was not displaying them corr
I am having an issue with 7.3.4 vs 8.0.3.
I have done a simple conversion of one of my databases from 7.3.4 to
8.0.3. I used the 8.0.3 pg_dump to dump the database and load via
psql 8.0.3.
However, I am having a problem. I have a query that our application
generates that is returning different
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> The problem only shows up when you have mixed data -- say, you have two
> applications, one website in PHP which inserts data in Latin-1, and a
> Windows app which inserts in UTF-8. In this case your data will be a
> mess to fix, and there's no way a si
Tom Lane <[EMAIL PROTECTED]> writes:
> "Salem Berhanu" <[EMAIL PROTECTED]> writes:
> > What exactly is the SQL_ASCII encoding in postgres?
>
> SQL_ASCII isn't so much an encoding as the declaration that you don't
> care about encodings.
It's too late to consider renaming this SQL_RAW or someth
On Tue, Aug 09, 2005 at 01:27:55PM -0400, Chris Hoover wrote:
> When I connect to a 7.3.4 database, the query returns 0 rows and a
> sqlca.sqlcode of 0
>
> However, when I connect to an 8.0.3 database, the query returns 0 rows
> and a sqlca.sqlcode of 100.
You don't mention it but it sounds like
Sorry, I should have given some setup details.
First off, we are running 8.0.3 from the postgresql.org rpms on RHEL AS 4.
7.3.4 is running on RHEL AS 2.1 installed from source.
What is ECPG?
Anyway, I'm not sure how to give you a simple example. We are running
a cobol application that is connec
Michael Fuhr <[EMAIL PROTECTED]> writes:
> I just did some tests with 7.3.10 and 8.0.3 and both returned a
> sqlca.sqlcode of 100 for a query that returned no rows. Either
> something changed between 7.3.4 and 7.3.10 or my test didn't
> duplicate what you're doing.
According to the CVS logs, ecpg
I have successfully moved the schema over to PostgreSQL.
Now I am working on the data.
In reviewing my tables, I found that for some strange reason a handful
of fields are not double-quoted. Strange quirk:
-- Table: "Orders"
-- DROP TABLE "Orders";
CREATE TABLE "Orders"
(
"OrderID" int4 N
Chris Hoover <[EMAIL PROTECTED]> writes:
> Anyway, I'm not sure how to give you a simple example. We are running
> a cobol application that is connecting to PostgreSQL via odbc. The
> application runs on one linux box and the database on a seperate one.
Hmm. I seriously doubt that the server's
Tom,
I'll send this over to the odbc list. However, the odbc driver is
liked into our cobol environment. I did not change the driver. We
are running the 7.2.5 odbc driver. This is why I am pointing to a
difference in the db responses.
The entire environment is the exactly same except for the
Chris Hoover <[EMAIL PROTECTED]> writes:
> This is what is pointing me to a problem with one of the db's. It
> appears that the sqlca code has had to of changed between the 7.3.4
> and 8 code and is now behaving in a different (and unexpected) manner.
There is no "sqlca" in the backend protocol a
>In reviewing my tables, I found that for some strange reason a handful
>of fields are not double-quoted. Strange quirk:
>-- Table: "Orders"
>
>-- DROP TABLE "Orders";
>
>CREATE TABLE "Orders"
>(
> "OrderID" int4 NOT NULL,
> "CustomerID" int4 NOT NULL,
> "DateCreated" timestamptz,
> "TotalPri
On Tue, Aug 09, 2005 at 02:44:08PM -0600, Michael Fuhr wrote:
> I wonder if the sqlcode value of 0 on which you're relying is
> correct, since SQL-92 mentions a value of 100 as meaning "no data."
> (BTW, SQL-92 deprecates SQLCODE, and SQL:1999 appears to have removed
> it altogether.)
...none of w
On Tue, Aug 09, 2005 at 03:03:03PM -0400, Chris Hoover wrote:
> What is ECPG?
Embedded SQL in C. I mentioned it because it's the only thing in
the standard PostgreSQL source code or documentation that contains
the string "sqlca":
http://www.postgresql.org/docs/8.0/static/ecpg.html
> Anyway, I'm
hello, I'm trying to recover files from a backup but I received this :
amrestore: could not fsf /dev/nst0: Input/output error
my cmd : amrestore /dev/nst0 ravenna /var/lib/pgsql/backups
I tried on 2 tapes , but I always have this error :(
---(end of broadcast)
Ben Kim <[EMAIL PROTECTED]> writes:
>> In reviewing my tables, I found that for some strange reason a handful
>> of fields are not double-quoted. Strange quirk:
>> ...
> In my case, DTS's "create" always wrapped the field names with double
> quote. The script seems to me not from DTS.
I think i
FM <[EMAIL PROTECTED]> writes:
> hello, I'm trying to recover files from a backup but I received this :
> amrestore: could not fsf /dev/nst0: Input/output error
I'm afraid you are asking the wrong list. Whatever amrestore is,
it's not software produced by the Postgres project.
28 matches
Mail list logo
