Ayende @ Rahien

Hi!
My name is Ayende Rahien
Founder of Hibernating Rhinos LTD and RavenDB.
You can reach me by phone or email:

ayende@ayende.com

+972 52-548-6969

@

Posts: 5,947 | Comments: 44,540

filter by tags archive

Data Migrations Woes


For some reason, customers insist on putting their data in a database, which is all fine and dandy. But then they also insist on taking it out! Which is hardly fine at all.

The fun part starts when the source is a little known database called Oracle, and the destination is a new arival from out of town, who goes by the nick name SQL Server.

Fun stuff that I run into today:

  • PK in Oracle are Number, in SQL Server, it is interpreted as double or float. Do try to query for Id = 12324.432154
  • Wierd PK - such as 1,001,0004,001,000 - a real PK that I run into today. No idea how it got to this point.

I am using both P/L SQL Developer and SQL Plus, and I have to say that both have some distinct advantages over SQL Server Management Studio. Just Ctrl+Click is an invaluable assest when you try to figure out what you are doing.


Comments

Alessandro Riolo

Is the 0004 in 1,001,0004,001,000 a typo?

Ayende Rahien

Nope, that is literally the PK of the row.

Comment preview

Comments have been closed on this topic.

FUTURE POSTS

No future posts left, oh my!

RECENT SERIES

  1. RavenDB Sharding (2):
    21 May 2015 - Adding a new shard to an existing cluster, the easy way
  2. The RavenDB Comic Strip (2):
    20 May 2015 - Part II – a team in trouble!
  3. Challenge (45):
    28 Apr 2015 - What is the meaning of this change?
  4. Interview question (2):
    30 Mar 2015 - fix the index
  5. Excerpts from the RavenDB Performance team report (20):
    20 Feb 2015 - Optimizing Compare – The circle of life (a post-mortem)
View all series

RECENT COMMENTS

Syndication

Main feed Feed Stats
Comments feed   Comments Feed Stats