Hi, everybody!.
I=B4m very new using XML and PostgreSQL so I have some questions:
1) I would like to know if there is a way to convert a query SQL and
return the request in an XML document. I=B4m using PostgreSQL to
devoloping the database. How I could to do this?
2) What is the principal advantage to do this?
3) Somebody know if there is somebody working with this? (study case,
articles, papers, journals, universities).
Thanks.
JoanaJoana G. Malaverri wrote:
> Hi, everybody!.
> Im very new using XML and PostgreSQL so I have some questions:
> 1) I would like to know if there is a way to convert a query SQL and
> return the request in an XML document. Im using PostgreSQL to
> devoloping the database. How I could to do this?
See the documentation
<URL:http://www.postgresql.org/docs/8.2/...tatype-xml.html>.
Note that this newsgroup is about XML in Microsoft SQL Server, if you
need further help with Postgres then a newsgroup, forum or mailing list
dedicated to Postgres seems a better place to look for.
Martin Honnen -- MVP XML
http://JavaScript.FAQTs.com/
Showing posts with label postgresql. Show all posts
Showing posts with label postgresql. Show all posts
Wednesday, March 21, 2012
Postgresql migration tool?
I have a postgres db and would like to convert to SQL Express or standard edition. Is there a conversion or migration tool available?
I can dump the postgres db to a sql file but MS has slightly different syntax and datatypes so I have to go in a manually modify the sql file for every table and data type. Is there an easier way? Thanks!
I'm not aware of any such tool from Microsoft but I've moved this thread to the database engine forum where you're more likely to find a knowledgeable answer.
Paul
PostgreSQL Database and Reporting Service?
Hello all -
I have reporting services installed on SQL server 2000 database and have
developed many many great reporrts on it.
However, I have the need now to address datasources from PostgreSQLdatabase
open-source database and I wonder if RS would work with PostgreSQL ODBC and
if the only thing I need is to establish an ODBC connection to the database?
Thanks for the info in advance.
wise -
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200609/1you can always make linked servers to the postgres database; and then
setup some queries as views on the SQL Server side..
then you're doing RS against SQL 2000 which is calling queries on
postgres
-Aaron
wiseteufel via SQLMonster.com wrote:
> Hello all -
> I have reporting services installed on SQL server 2000 database and have
> developed many many great reporrts on it.
> However, I have the need now to address datasources from PostgreSQLdatabase
> open-source database and I wonder if RS would work with PostgreSQL ODBC and
> if the only thing I need is to establish an ODBC connection to the database?
> Thanks for the info in advance.
> wise -
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200609/1|||thanks dbaHooker .. i will try that. will see what drivers postgres has!!
dbahooker@.hotmail.com wrote:
>you can always make linked servers to the postgres database; and then
>setup some queries as views on the SQL Server side..
>then you're doing RS against SQL 2000 which is calling queries on
>postgres
>-Aaron
>> Hello all -
>[quoted text clipped - 12 lines]
>> Message posted via SQLMonster.com
>> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200609/1
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200609/1
I have reporting services installed on SQL server 2000 database and have
developed many many great reporrts on it.
However, I have the need now to address datasources from PostgreSQLdatabase
open-source database and I wonder if RS would work with PostgreSQL ODBC and
if the only thing I need is to establish an ODBC connection to the database?
Thanks for the info in advance.
wise -
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200609/1you can always make linked servers to the postgres database; and then
setup some queries as views on the SQL Server side..
then you're doing RS against SQL 2000 which is calling queries on
postgres
-Aaron
wiseteufel via SQLMonster.com wrote:
> Hello all -
> I have reporting services installed on SQL server 2000 database and have
> developed many many great reporrts on it.
> However, I have the need now to address datasources from PostgreSQLdatabase
> open-source database and I wonder if RS would work with PostgreSQL ODBC and
> if the only thing I need is to establish an ODBC connection to the database?
> Thanks for the info in advance.
> wise -
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200609/1|||thanks dbaHooker .. i will try that. will see what drivers postgres has!!
dbahooker@.hotmail.com wrote:
>you can always make linked servers to the postgres database; and then
>setup some queries as views on the SQL Server side..
>then you're doing RS against SQL 2000 which is calling queries on
>postgres
>-Aaron
>> Hello all -
>[quoted text clipped - 12 lines]
>> Message posted via SQLMonster.com
>> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200609/1
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200609/1
PostgreSQL
In a Union query, I have initialized one new column for sorting purpose. For
ex :
select ORD = 1 , t1.a, t1.b from table1 as t1
Union
select ORD = 0, t2.a, t2.b from table2 as t2
order by ORD.
ORD column is not present in thw table. It is used here for putting all the
rows of the second query before the rows of first query. The query is
getting executed in Windows which uses SQL 2000 server. But in Linux(RedHat)
when we are using PostgresSQL database, the same query gives error - "Unable
to parse 'ORD' ".
Is this thing not supported in PostgresSQL? If this is not supported then
what is the method of acheiving the same result?
Thanks,
Venkat
Try:
select 1 AS ORD , t1.a, t1.b from table1 as t1
Union
select 0, t2.a, t2.b from table2 as t2
order by ORD
column_alias = expression is T-SQL specific and not ANSI-SQL standard, as
opposed to expression AS column_alias which is standard SQL.
Jacco Schalkwijk
SQL Server MVP
"Venkat" <venkat_kp@.yahoo.com> wrote in message
news:1092226310.253625@.sj-nntpcache-5...
> In a Union query, I have initialized one new column for sorting purpose.
> For
> ex :
> select ORD = 1 , t1.a, t1.b from table1 as t1
> Union
> select ORD = 0, t2.a, t2.b from table2 as t2
> order by ORD.
> ORD column is not present in thw table. It is used here for putting all
> the
> rows of the second query before the rows of first query. The query is
> getting executed in Windows which uses SQL 2000 server. But in
> Linux(RedHat)
> when we are using PostgresSQL database, the same query gives error -
> "Unable
> to parse 'ORD' ".
> Is this thing not supported in PostgresSQL? If this is not supported then
> what is the method of acheiving the same result?
>
> Thanks,
> Venkat
>
>
|||"Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid > wrote
in message news:#YjU$q7fEHA.2848@.TK2MSFTNGP10.phx.gbl...
> Try:
> select 1 AS ORD , t1.a, t1.b from table1 as t1
> Union
> select 0, t2.a, t2.b from table2 as t2
> order by ORD
> column_alias = expression is T-SQL specific and not ANSI-SQL standard, as
> opposed to expression AS column_alias which is standard SQL.
>
Thanks Jacco it worked for me.
regards,
Venkat
ex :
select ORD = 1 , t1.a, t1.b from table1 as t1
Union
select ORD = 0, t2.a, t2.b from table2 as t2
order by ORD.
ORD column is not present in thw table. It is used here for putting all the
rows of the second query before the rows of first query. The query is
getting executed in Windows which uses SQL 2000 server. But in Linux(RedHat)
when we are using PostgresSQL database, the same query gives error - "Unable
to parse 'ORD' ".
Is this thing not supported in PostgresSQL? If this is not supported then
what is the method of acheiving the same result?
Thanks,
Venkat
Try:
select 1 AS ORD , t1.a, t1.b from table1 as t1
Union
select 0, t2.a, t2.b from table2 as t2
order by ORD
column_alias = expression is T-SQL specific and not ANSI-SQL standard, as
opposed to expression AS column_alias which is standard SQL.
Jacco Schalkwijk
SQL Server MVP
"Venkat" <venkat_kp@.yahoo.com> wrote in message
news:1092226310.253625@.sj-nntpcache-5...
> In a Union query, I have initialized one new column for sorting purpose.
> For
> ex :
> select ORD = 1 , t1.a, t1.b from table1 as t1
> Union
> select ORD = 0, t2.a, t2.b from table2 as t2
> order by ORD.
> ORD column is not present in thw table. It is used here for putting all
> the
> rows of the second query before the rows of first query. The query is
> getting executed in Windows which uses SQL 2000 server. But in
> Linux(RedHat)
> when we are using PostgresSQL database, the same query gives error -
> "Unable
> to parse 'ORD' ".
> Is this thing not supported in PostgresSQL? If this is not supported then
> what is the method of acheiving the same result?
>
> Thanks,
> Venkat
>
>
|||"Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid > wrote
in message news:#YjU$q7fEHA.2848@.TK2MSFTNGP10.phx.gbl...
> Try:
> select 1 AS ORD , t1.a, t1.b from table1 as t1
> Union
> select 0, t2.a, t2.b from table2 as t2
> order by ORD
> column_alias = expression is T-SQL specific and not ANSI-SQL standard, as
> opposed to expression AS column_alias which is standard SQL.
>
Thanks Jacco it worked for me.
regards,
Venkat
PostgreSQL
In a Union query, I have initialized one new column for sorting purpose. For
ex :
select ORD = 1 , t1.a, t1.b from table1 as t1
Union
select ORD = 0, t2.a, t2.b from table2 as t2
order by ORD.
ORD column is not present in thw table. It is used here for putting all the
rows of the second query before the rows of first query. The query is
getting executed in Windows which uses SQL 2000 server. But in Linux(RedHat)
when we are using PostgresSQL database, the same query gives error - "Unable
to parse 'ORD' ".
Is this thing not supported in PostgresSQL? If this is not supported then
what is the method of acheiving the same result?
Thanks,
VenkatTry:
select 1 AS ORD , t1.a, t1.b from table1 as t1
Union
select 0, t2.a, t2.b from table2 as t2
order by ORD
column_alias = expression is T-SQL specific and not ANSI-SQL standard, as
opposed to expression AS column_alias which is standard SQL.
Jacco Schalkwijk
SQL Server MVP
"Venkat" <venkat_kp@.yahoo.com> wrote in message
news:1092226310.253625@.sj-nntpcache-5...
> In a Union query, I have initialized one new column for sorting purpose.
> For
> ex :
> select ORD = 1 , t1.a, t1.b from table1 as t1
> Union
> select ORD = 0, t2.a, t2.b from table2 as t2
> order by ORD.
> ORD column is not present in thw table. It is used here for putting all
> the
> rows of the second query before the rows of first query. The query is
> getting executed in Windows which uses SQL 2000 server. But in
> Linux(RedHat)
> when we are using PostgresSQL database, the same query gives error -
> "Unable
> to parse 'ORD' ".
> Is this thing not supported in PostgresSQL? If this is not supported then
> what is the method of acheiving the same result?
>
> Thanks,
> Venkat
>
>|||"Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid> wrote
in message news:#YjU$q7fEHA.2848@.TK2MSFTNGP10.phx.gbl...
> Try:
> select 1 AS ORD , t1.a, t1.b from table1 as t1
> Union
> select 0, t2.a, t2.b from table2 as t2
> order by ORD
> column_alias = expression is T-SQL specific and not ANSI-SQL standard, as
> opposed to expression AS column_alias which is standard SQL.
>
Thanks Jacco it worked for me.
regards,
Venkat
ex :
select ORD = 1 , t1.a, t1.b from table1 as t1
Union
select ORD = 0, t2.a, t2.b from table2 as t2
order by ORD.
ORD column is not present in thw table. It is used here for putting all the
rows of the second query before the rows of first query. The query is
getting executed in Windows which uses SQL 2000 server. But in Linux(RedHat)
when we are using PostgresSQL database, the same query gives error - "Unable
to parse 'ORD' ".
Is this thing not supported in PostgresSQL? If this is not supported then
what is the method of acheiving the same result?
Thanks,
VenkatTry:
select 1 AS ORD , t1.a, t1.b from table1 as t1
Union
select 0, t2.a, t2.b from table2 as t2
order by ORD
column_alias = expression is T-SQL specific and not ANSI-SQL standard, as
opposed to expression AS column_alias which is standard SQL.
Jacco Schalkwijk
SQL Server MVP
"Venkat" <venkat_kp@.yahoo.com> wrote in message
news:1092226310.253625@.sj-nntpcache-5...
> In a Union query, I have initialized one new column for sorting purpose.
> For
> ex :
> select ORD = 1 , t1.a, t1.b from table1 as t1
> Union
> select ORD = 0, t2.a, t2.b from table2 as t2
> order by ORD.
> ORD column is not present in thw table. It is used here for putting all
> the
> rows of the second query before the rows of first query. The query is
> getting executed in Windows which uses SQL 2000 server. But in
> Linux(RedHat)
> when we are using PostgresSQL database, the same query gives error -
> "Unable
> to parse 'ORD' ".
> Is this thing not supported in PostgresSQL? If this is not supported then
> what is the method of acheiving the same result?
>
> Thanks,
> Venkat
>
>|||"Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid> wrote
in message news:#YjU$q7fEHA.2848@.TK2MSFTNGP10.phx.gbl...
> Try:
> select 1 AS ORD , t1.a, t1.b from table1 as t1
> Union
> select 0, t2.a, t2.b from table2 as t2
> order by ORD
> column_alias = expression is T-SQL specific and not ANSI-SQL standard, as
> opposed to expression AS column_alias which is standard SQL.
>
Thanks Jacco it worked for me.
regards,
Venkat
PostgreSQL
wkstn: Win XP
SQL Server 2000(local, on wkstn)
I'm trying to connect to a PostgreSQL(on RedHat linux
server) database using the latest PostgreSQL ODBC driver
(07.03.0200) (trying)within SQL server via Import wizard
and DTS package...I keep getting this error: "Multiple-
step OLE DB operation generated errors. Check each OLE DB
status value, if available. No work was done." I searched
Knowledge Base and received info, but none that addressed
this specific issue. I am able to connect through MS
Access 2002.
Any suggestions?Mike,
Try connecting to PostgreSQL from a different tool such as WinSQL just
to make sure there is no problem with the ODBC driver.
Pete
MikeM wrote:
You don't pay to get spam, why pay to clean it?
Visit http://www.spammarshall.com to create an account for free
<http://www.spammarshall.com>
SQL Server 2000(local, on wkstn)
I'm trying to connect to a PostgreSQL(on RedHat linux
server) database using the latest PostgreSQL ODBC driver
(07.03.0200) (trying)within SQL server via Import wizard
and DTS package...I keep getting this error: "Multiple-
step OLE DB operation generated errors. Check each OLE DB
status value, if available. No work was done." I searched
Knowledge Base and received info, but none that addressed
this specific issue. I am able to connect through MS
Access 2002.
Any suggestions?Mike,
Try connecting to PostgreSQL from a different tool such as WinSQL just
to make sure there is no problem with the ODBC driver.
Pete
MikeM wrote:
quote:
>wkstn: Win XP
>SQL Server 2000(local, on wkstn)
>I'm trying to connect to a PostgreSQL(on RedHat linux
>server) database using the latest PostgreSQL ODBC driver
>(07.03.0200) (trying)within SQL server via Import wizard
>and DTS package...I keep getting this error: "Multiple-
>step OLE DB operation generated errors. Check each OLE DB
>status value, if available. No work was done." I searched
>Knowledge Base and received info, but none that addressed
>this specific issue. I am able to connect through MS
>Access 2002.
>Any suggestions?
>
You don't pay to get spam, why pay to clean it?
Visit http://www.spammarshall.com to create an account for free
<http://www.spammarshall.com>
Wednesday, March 7, 2012
possible to access postgresql from sql server ce
I am wondering if it is possible to access a remote postgresql database using the sql server ce access classes. I do not want to run a postgresql server on windows ce, just access one from a mobile device.
No, you can not. As name implies you can only access SQL Server CE with SQL Server CE access classes.
|||Thanks for your reply. I guess the real question I have is: Is thereany way to access a remote database that supports ODBC using Windows CE and Visual Studio .Net?|||
Windows CE has no support for ODBC. It has support for OLEDB, but there's no OLEDB ADO.Net provider not to mention you'd need Postgre OLEDB driver for Windows CE and I doubt Postgre has one.
|||Spasiba|||After doing a little research based on what you said I would need, Idid find a beta OLEDB provider for postgresql
http://pgfoundry.org/projects/oledb/ (which may or may not work on CE)
But if there's not Ado.net provider for CE, then it's a moot point.|||
If you get it to work you can use COM interop to talk to database instead of ADO.Net. May be not as convenient, but should work.
Now, using LGPL beta code which you need to port to CE first is another story…
Subscribe to:
Posts (Atom)