Converting SQL Server code to PostgreSQL

If you've spent years writing T-SQL and SQL Server, switching to Postgres can feel extra awkward. The syntax is close, but not quite, and those small differences can really trick you up. Google Cloud's Database Migration Service acts like a hands-on translator. It lets you explore Postgres fundamentals using the schemas you already know, so you can learn faster with fewer roadblocks. [music] Here's a standard SQL Server create table statement for a products table. [music] On the right is the Postgres version that DMS generated automatically. Let's break down the key differences. [music] First up, the primary key. T-SQL uses identity for auto-incrementing IDs. DMS maps this to Postgres's identity. Is there any difference between them? Let's ask Gemini. >> [music] >> Gemini explains that DMS uses the recommended SQL standard compliant syntax, generated as identity. DMS also educates us about Postgres version differences. Until version 10, it relied on a specific pseudo type called serial to achieve this. In one click, Gemini [music] has educated and shown us the Postgres way to handle auto-incrementing keys without needing to search or guess. >> [music] >> Next, the is active column. SQL Server uses the bit data type. DMS maps it to boolean. Gemini confirms this is the idiomatic type for true false values in Postgres. A common mistake here is defaulting to an int for flags when Postgres already gives you a proper boolean type. >> [music] >> Finally, the default value for our timestamp. T-SQL uses getdate. [music] DMS maps this to Postgres's local timestamp. Local timestamp is the standard Postgres [music] function for returning the current time without time zone information at the start of the transaction. [music] That makes it the correct equivalent for getdate. DMS also notes the mapping from datetime [music] two to timestamp without time zone, which can be shortened to timestamp, to ensure precision and time zone unaware behaviors are maintained. These small, accurate translations add up. >> [music] >> With Gemini and DMS, you don't have to stop and search every unfamiliar keyword. You recognize the pattern, >> [music] >> apply what you know, and keep moving. Are you ready to start? Use the DMS conversion workspace to migrate your own SQL Server code today. The link is in the description below. >> [music] [music]