Tagged Questions
1
vote
1answer
76 views
How does MS SQL Server authenticate MSDTC connections when using SSPI?
I'm trying to get SSPI authentication to play well with two-phase transactions via MSDTC, using PostgreSQL with psqlODBC. I can't figure out how it can work securely - so I'm hoping someone can ...
2
votes
1answer
66 views
MS SQL - export tables to format compatible with PostgreSQL
We're using MS SQL Server 2005 at work and I want to export our data to PostgreSQL for testing.
MS SQL Server has an export function but the only one that looks like it would work would be to export ...
1
vote
3answers
279 views
What's the most efficient UUID column type
For storing a 128 bits UUID there are multiple storage options:
a byte[16] column
two bigint/long(64 bits) columns
a CHAR(36) column - 32 hex digits + 4 dashes.
a UUID database specific column, if ...
0
votes
0answers
65 views
Data Synchronization from SQL-Server to PostgreSQL
I am trying to figure out the best method for duplicating data in one-direction from a SQL-Server database to PostgreSQL. I know that there are no replication providers for SQL-Server to PostrgreSQL. ...
1
vote
2answers
117 views
What is a good solution for reliably transferring data between SQL Server and PostgreSQL?
In analyzing some of our business data, we're realizing that we need to join data across disparate data sources. For example, our application data is warehoused in Postgres (ported from MongoDB via ...
1
vote
1answer
87 views
Sync postgreSQL with SQL Server database- on data change event
I have one PostgreSQL database and its data are being changed regularly. I want to sync all its data with my SQL Server database. One thing I can do is use query to check all required tables and ...
0
votes
4answers
800 views
PostgreSQL 9.3 on Ubuntu Server 12.04 v.s. MS SQL Server 2008 R2 on Windows 7 Ultima
I have searched many articles in Google about the performance of PostgreSQL vs MS SQL 2008 R2 and found that many of those articles say the performance of PostgreSQL is better than that of MSSQL 2008 ...
1
vote
2answers
626 views
Migration from SQL Server 2008 to Postgres 9.2 [closed]
I have a rather large database (2 GB of data, 25 million rows in the largest table) on a shared web hosting. The database engine is Microsoft SQL Server 2008.
Due to high fees for the SQL Server web ...
1
vote
0answers
421 views
Why aren't unsigned integer types available in the top database platforms?
Databases are usually very customizable with varying data types and custom lengths.
It surprises me, as I try to look for the syntax to use unsigned int types that they are not available from neither ...
3
votes
2answers
298 views
Equivalents to `ora_rowscn` in other databases?
Do other databases other than Oracle have ora_rowscn (http://docs.oracle.com/cd/B19306_01/server.102/b14200/pseudocolumns007.htm) equivalents, or do you have to implement them yourself in your fields, ...
-2
votes
1answer
145 views
Query sql-server db and insert results into PostgreSQL
I have a query that returns data from sql-server and I need to be able to put the results into PostgreSQL. I'm using C# for the task.
2
votes
3answers
250 views
Monthly backup of SQL server DB to PostgreSQL?
The company I'm working for has a SQL Server with read-only access. They use Crystal Reports hooked up to PostgreSQL for reporting. Is there any way to make it so I can move all the data from the ...
0
votes
1answer
66 views
SQL Server fsync Options
PostgreSQL has the option to turn off fsync and synchronous commits (http://www.postgresql.org/docs/9.1/static/runtime-config-wal.html). Does SQL Server has this option somewhere?
3
votes
4answers
218 views
Changing the representation of NULLs in pg_dump plaintext output
I'm trying to convert a large-ish Postgres DB (500 GB) to SQL Server 2012. After investigating a few third-party tools and being disappointed in features, performance, or both, I started pursuing a ...
1
vote
0answers
130 views
Postgres books for a Sql Server DBA [closed]
I have a team of Sql Server DBAs and Architects. One of our newer teams is building a product exclusively on Postgres. Now, I need to make sure that we have the knowledge base to support this project. ...
4
votes
2answers
287 views
General tool to load dump files
I am a big fan of Postgres both for its price but also for its features.
I am going to have to need to upload into it both Oracle dump and SQL Server files.
I will try to ask and beg for plain .csv ...
3
votes
1answer
546 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.
3
votes
2answers
379 views
pessimistic locking and client death
We are considering pessimistic locking for our project (SELECT ... FOR UPDATE); as we are used to optimistic locking, we are afraid about the operation of the server being blocked on such a lock (lock ...
-3
votes
2answers
653 views
Versioning data in Databases [closed]
Is there any ready mechanism in Oracle, SQL Server, PostgreSql or OR framework (C#), which can version information in a database? By versioning informartion I mean that e.g. I have table Person (id, ...
1
vote
1answer
215 views
Efficient query plan for selecting all data duplicated on several columns
The flavour in question is PostgreSQL, but it is a generic enough query pattern that your techniques for optimising against other RDBMs should help as well.
The purpose of the query is to show all ...
7
votes
1answer
606 views
Equality query on NVARCHAR column yields multiple results in SQL Server 2012
I am in the process of moving a pet project from PostgreSQL (9.2.2) to SQL Server (2012 Standard).
I've noticed an interesting phenomenon when querying unicode words. Given the definition:
CREATE ...
3
votes
3answers
189 views
PostgreSQL equivalent of SQL Server SQL_VARIANT_PROPERTY
Does PostgreSQL have an equivalent function for determining column metadata?
Reference: SQL_VARIANT_PROPERTY
pg_typeof() appears to be close, but it does not show the precision and scale. Looking up ...
3
votes
2answers
568 views
SQL ANSI JOIN precedence
I have a query that looks like this:
SELECT *
FROM TBLA A
LEFT JOIN TBLB B ON A.Col1 = B.Col2
RIGHT JOIN TBLC C ON B.Col3 = C.Col4
JOIN TBLD D ON C.Col5 = D.Col6
In which order ...
8
votes
2answers
4k views
For absolute performance, is SUM faster or COUNT?
This relates to counting the number of records that match a certain condition, e.g. invoice amount > $100.
I tend to prefer
COUNT(CASE WHEN invoice_amount > 100 THEN 1 END)
However, this is ...
3
votes
1answer
1k views
How can I create a dblink from Postgresql 8.3 to SQL Server (2000 and 2008)?
I have a Postgresql database that need to read data from two SQL Servers (one SQL Server 2000 and one SQL Server 2008).
I want to setup two dblinks to the SQL Servers.
After googling, foruming, ...
0
votes
2answers
190 views
Transfer data from database1 to database2 using task queue
We have a SQL Server legacy database, db1, to put data of Project1. With change of certain tables(insert/update) in db1, we need to transfer the changes in another postgres database, db2 (used by ...
4
votes
1answer
150 views
I was interrupted while transferring a very large table. How can I pick it up from where it stopped?
I wrote a python script to select and insert rows between tables in different databases (from SQL Server to Postgres). the table has around 2000000000 rows and the transfer stopped somewhere in the ...
9
votes
3answers
993 views
PostgreSQL Initial Database Size
There are 2 parts to my question.
Is there a way of specifying the initial size of a database in PostgreSQL?
If there isn't, how do you deal with fragmentation when the database grows over time?
...
0
votes
2answers
491 views
Creating a test database from Production database (different machines & servers)
I'd like to set up a test database on a separate server. Production database is MS SQL Server and the test server is a *nix box so I'd like to have the test server running either PostgreSQL or MySQL.
...
0
votes
2answers
1k views
How to convert SQL Server .MDF database to Mac OS PostgreSQL database on Mac OS X?
I need to import a SQL Server database which is in the .mdf format into a PostgreSQL database. My system is Mac OS X.
How to do it in the easiest way?
-1
votes
1answer
312 views
Important distinctions between DBMSs [closed]
DBA is a career I'm strongly considering after school, but my limited experience mostly involves some PL/SQL Oracle web programming, some basic PHP/MySQL web pages, and some queries in SQL Server. ...
3
votes
2answers
522 views
How do I replicate SQL Server index INCLUDE and STATISTICS functionality on PostgreSQL?
I'm working on a project that must support two database engines; SQL Server and PostgreSQL.
We are using NHibernate as the ORM.
We are running into performance issues with certain queries. Using ...
2
votes
1answer
2k views
Copying the database from SQL Server to PostgreSQL
I currently have SQL Server 2005 and I want to make a copy of the entire database into PostgreSQL. I don't want to migrate to new PostgreSQL but just a entire copy. I almost have more than 1 TB of ...
6
votes
3answers
421 views
Is there a need to keep refreshing the indexes from time-to-time?
This question is common for all the database products I use, viz. SQL Server, MySQL, Oracle and PostgreSQL.
I have created a fresh database and the tables, at present, have no records. I have created ...
