Tagged Questions
2
votes
1answer
56 views
Is replication from SQL Server 2008 to PostgreSql possible?
Is it possible ? Sql Server as publisher(master) and PostgreSql as slave(subscriber) ? Any type of replication really.
0
votes
0answers
57 views
Migrate PostGIS geometry data to SQL Server spatial data
I am trying to migrate PostGIS geometry to SQL Server Spatial data. Which ETL I have to use?
It's the first time I'll work with SQL Server spatial features.
Thanks for any help
0
votes
2answers
208 views
migrate SQL Server geography data to PostGIS geometry data
I'm trying to use SSIS to transfer point data from a Geography column in SQL Server 2008 R2 to a geometry column in a Greenplum (Postgres 8.2.15) database with PostGIS. I know there's a way to do the ...
4
votes
3answers
529 views
How can I write a proper query to JOIN all of these tables without duplicates?
Let's say I have four tables:
TABLE: players
COLUMNS: id, first_name, last_name
TABLE: passing_stats
COLUMNS: id, year, passing_yards (several other passing columns)
TABLE: rushing_stats
...
1
vote
4answers
945 views
migrating tables from Postgres to SQL Server 2008
(I fear what I wish to accomplish shall not be easy, but a lot of my googling around about it yielded rather dated results, so here it goes...)
I have a Postgres 8.4.x database with over 100 tables. ...
3
votes
1answer
286 views
querying a linked PostgreSQL database in SQL Server 2008
We will be deploying an application with a Postgres back-end and need to provide report writing capabilities in SQL Server. I am exploring options for real-time or near real-time reporting in this ...
