# Migrate multilingual full-text search from SQL Server to PostgreSQL

DevFeed: [Migrate multilingual full-text search from SQL Server to PostgreSQL](<https://devfeed.tech/articles/migrate-multilingual-full-text-search-from-sql-server-to-postgresql-4704.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/migrate-multilingual-full-text-search-from-sql-server-to-postgresql/>)

Author: Ken Zhang

Published: 2026-08-20T20:34:44Z

Content type: tutorial

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [sql-server](<https://devfeed.tech/topics/sql-server.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [tokenization](<https://devfeed.tech/topics/tokenization.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon](<https://devfeed.tech/tags/amazon.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [aws](<https://devfeed.tech/tags/aws.md>), [blog](<https://devfeed.tech/tags/blog.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [postgresql-compatible](<https://devfeed.tech/tags/postgresql-compatible.md>), [rds-for-postgresql](<https://devfeed.tech/tags/rds-for-postgresql.md>), [sql](<https://devfeed.tech/tags/sql.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>), [tokenization](<https://devfeed.tech/tags/tokenization.md>)

## AI overview

This tutorial explains how to migrate multilingual full-text search from SQL Server to PostgreSQL while preserving comparable behavior. It covers collations, text search configurations, language-specific tokenization, accent-insensitive search, synonym expansion, and validation testing on Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL.

## Source excerpt

Migrating full-text search from SQL Server to PostgreSQL can silently change results because the engines handle text, linguistics, and accents differently. This post shows how to reproduce SQL Server full-text search on Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL, covering collation, tokenization, accent-insensitive search, and synonyms.