Migrating from SQL Server to PostgreSQL   Checkout our PostGIS in Action book 2nd Edition. First chapter is a free download

Postgres OnLine Journal

Blog View    Periodical View   PostGIS in Action   About the Authors   Consulting



Saturday, November 09. 2013


Migrating from SQL Server to PostgreSQL

Printer Friendly

Alexander Kuznetsov on SQLblog.com has an interesting series going entitled with Learning PostgreSQL. In the series he focuses on what it takes to move a SQL Server database and App to PostgreSQL and highlights some of the key differences between the two platforms that you should watch out for. I recommend it to any SQL Server developer planning to make the switch to PostgreSQL or any PostgreSQL consultant tasked with the job and not familiar with the intricacies of SQL Server.

His PostgreSQL feed can be found here here

So far on his list of articles in the series:

  1. Learning PostgreSQL: First Steps
  2. Learning PostgreSQL: Reading and Writing from .NET
  3. Learning PostgreSQL: Functions and refcursors
  4. Learning PostgreSQL: bulk loading data
  5. Learning PostgreSQL: overloading
  6. Learning PostgreSQL: old versions of rows are stored right in the table
Posted by Leo Hsu and Regina Obe in 9.2, 9.3, basics, other dbms, postgresql versions, sql server at 12:53 | Comments (3) | Trackbacks (0)

Trackbacks
Trackback specific URI for this entry

No Trackbacks


Comments
Display comments as (Linear | Threaded)

The list of articles has a duplicate. It just so happens that I've been writing about why duplicate tuples (rows) are not part of the relational model, and I can't help but think that your list makes a good example for my arguments :-)
#1 Joe Abbate on 2013-11-10 09:15 (Reply)
Thanks got rid of the duplicate article.
#1.1 Regina on 2013-12-06 21:15 (Reply)
I haven't read all his posts, merely searched them for 'optimizer', but I think it's worth mentioning that differences between how the query optimizers work can result in a few rather nasty performance issues, particularly with queries with lots of joins or big/complex views and a few joins.
I'll try to comment on one of his posts when I'll have the time.
#2 Slapo (Homepage) on 2013-11-12 04:48 (Reply)

Add Comment

E-Mail addresses will not be displayed and will only be used for E-Mail notifications.

To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly.
CAPTCHA
 
 

Entry's Links

Quicksearch

Calendar

Back November '24
Mon Tue Wed Thu Fri Sat Sun
        1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30  

Categories

All categories

Archives

Subscribe

  • XML

Blog Administration

Open login screen