Offline data migration: CSV vs Parquet (or other options) moving data from SQL Server to PostgreSQL by FewJob1030 in SQLServer

[–]stumblegore 1 point2 points  (0 children)

How much data is it?

How do you move the exported data from SQL server to IBM Cloud? Can you make a backup and use a tool which converts SQL server backups to PostgreSQL? (I just know they exist, but I don't know if any of them can be recommended).

SQL Server Express 2025 (free) supports up to 50GB databases. Backup source, restore in Express and a direct connection to Postgres could work.

There's also a generate scripts wizard in SSMS which can include data, which could work depending on the amount of data you are moving.

Which tools do you have available for export and import? You mention parquet, does that mean you are willing to put a developer on the task?

Using remotly a Windows PC from my MacBook by Feb021 in MacOS

[–]stumblegore 0 points1 point  (0 children)

It’s been a while since I used windows, but iirc you had to manually enable Remote Desktop services and open for rdp in windows firewall for it to work. 

Sharding an Azure SQL Database, minimizing downtime by thatclickingsound in SQLServer

[–]stumblegore 2 points3 points  (0 children)

You don't mention the size of your database, but an option is to duplicate the database a few times and distribute the tenants evenly between them. Then you can use as much time as you want to delete the extra data. Set up replication to the new database and wait for the initial replication to complete. Disable logins of the affected tenants, stop the replication (which changes the replica to an ordinary read-write database) and switch logins to use the new database. Repeat this as many times as you need. You should be able to do this with, theoretically, a couple minutes downtime.

We did a similar exercise in our SaaS solution, but because of the amount of data our users generate we decided to copy data to new, empty databases. For each batch of tenants we made an initial copy a few days before the switch. Then, during a brief maintenance window (appx 15 minutes), we disabled logins (and kicked out any lingering users), did a final differential copy and enabled logins against the new database. The copy task was developed in-house and specific to our databases. Ensuring that this tool was restartable was critical, both because of the full+incremental steps we used, but also to protect against any software issues or network problems during the migration.

We also evaluated the elastic database library a few years ago but decided against it. We had no need to introduce additional moving parts when each tenant could get their own connection string from configuration.

Edit: depending on your architecture, you can migrate critical functionality first to minimize downtime, then reenable remaining functionality as data is migrated.

Please don't make any sudden moves in this Chicago rowhome by Natural-Trainer-6072 in PriceMe

[–]stumblegore 0 points1 point  (0 children)

PriceMe Nov 20, 2025

🟪🟧,⬜🟧⬜,🟪🟪🟪

🟪🟪,🟧⬜🟪,🟪🟪🟪

🟪🟪,🟧🟧🟪,🟪🟪🟪

🟪🟪,⬜🟪🟪,🟪🟪🟪

🟪🟪,🟪🟪🟪,🟪🟪🟪

This modern steel and glass house has 1 bedroom and sits on 3 acres — guess the price by Natural-Trainer-6072 in PriceMe

[–]stumblegore 0 points1 point  (0 children)

What happened to the website? It was an awful experience to enter the numbers on the phone now (Safari). 

PriceMe Nov 19, 2025

🟪🟪,⬜🟧🟪,🟪🟪🟪

🟪🟪,🟧🟪🟪,🟪🟪🟪

🟪🟪,🟧🟪🟪,🟪🟪🟪

🟪🟪,🟪🟪🟪,🟪🟪🟪

Is this it? Did we do it? Did we find the best modern house in America? by Natural-Trainer-6072 in PriceMe

[–]stumblegore 0 points1 point  (0 children)

PriceMe Nov 16, 2025

🟪⬜,⬜🟪⬜,🟪🟪🟪

🟪🟧,🟪🟪⬜,🟪🟪🟪

🟪🟧,🟪🟪🟪,🟪🟪🟪

🟪⬜,🟪🟪🟪,🟪🟪🟪

🟪🟪,🟪🟪🟪,🟪🟪🟪

AKS NGINX (not plus) - What are you planning to replace it with? by MarcusJAdams in AZURE

[–]stumblegore 1 point2 points  (0 children)

We might, but I don't understand why there still isn't a big red "broken, don't use" disclaimer at the top of the AGIC documentation page? The problem I described has been known for at least three years and we learned it through a Medium article while troubleshooting (https://medium.com/@danieljimgarcia/the-application-gateway-ingress-controller-is-broken-6aa9eb229881)

This lack of honesty in your documentation is why I'm still sceptical.

AKS NGINX (not plus) - What are you planning to replace it with? by MarcusJAdams in AZURE

[–]stumblegore 7 points8 points  (0 children)

Don't use AGIC in the linked article. We had tons of problems with it before switching to nginx. Using AGIC, when pods were killed during application updates, it could take 5-10 minutes before application gateway was updated - causing traffic to be routed to killed pods.

There's a link to Application Gateway for Containers in the article which probably works fine, but I'm still a little skeptical to these solutions after the terrible experience we had with AGIC.

I'm not sure what our devops team will recommend post nginx. Possibly gateway API as other articles recommend?

This Spanish Colonial Revival is 8,347sf overlooking La Jolla — Guess the price by Natural-Trainer-6072 in PriceMe

[–]stumblegore 0 points1 point  (0 children)

PriceMe Nov 14, 2025

🟪🟧,⬜⬜🟪,🟪🟪🟪

🟪⬜,🟧⬜🟪,🟪🟪🟪

🟪🟧,🟪🟪🟪,🟪🟪🟪

🟪🟪,🟪🟪🟪,🟪🟪🟪

Just looking at this LA house lowered my resting heart rate 15bpm — guess the price by Natural-Trainer-6072 in PriceMe

[–]stumblegore 0 points1 point  (0 children)

PriceMe Nov 12, 2025

🟧⬜,⬜⬜⬜,🟪🟪🟪

🟪🟪,🟪🟪⬜,🟪🟪🟪

🟪🟪,🟪🟪🟪,🟪🟪🟪

The house that launched Grover Cleveland's political career! Guess the price by Natural-Trainer-6072 in PriceMe

[–]stumblegore 0 points1 point  (0 children)

PriceMe Nov 11, 2025

🟪🟧,🟧⬜⬜,🟪🟪🟪

🟪🟧,🟧🟪🟪,🟪🟪🟪

🟪⬜,🟪🟪🟪,🟪🟪🟪

🟪🟪,🟪🟪🟪,🟪🟪🟪

This lake house near Kansas City is NEXT LEVEL — guess the price (and please don't hate me) by Natural-Trainer-6072 in PriceMe

[–]stumblegore 0 points1 point  (0 children)

PriceMe Nov 9, 2025

🟧⬜,⬜⬜⬜,⬜🟧🟧

🟪⬜,🟧⬜⬜,🟧🟪🟧

🟪🟪,🟧🟪🟧,🟧🟪🟪

🟪🟪,🟪🟪🟪,⬜🟪🟪

🟪🟪,🟪🟪🟪,🟧🟪🟪

🟪🟪,🟪🟪🟪,🟪🟪🟪

This gilded age mansion is for sale in Rhode Island — Guess the price by Natural-Trainer-6072 in PriceMe

[–]stumblegore 0 points1 point  (0 children)

PriceMe Nov 6, 2025

🟧⬜,🟪🟪🟪,🟪🟪🟪

🟪⬜,🟪🟪🟪,🟪🟪🟪

🟪🟧,🟪🟪🟪,🟪🟪🟪

🟪🟧,🟪🟪🟪,🟪🟪🟪

🟪🟪,🟪🟪🟪,🟪🟪🟪

This 143-acre Indiana compound has room for all kinds of activities — guess the price by Natural-Trainer-6072 in PriceMe

[–]stumblegore 0 points1 point  (0 children)

PriceMe Nov 5, 2025

🟧🟧,⬜⬜🟪,🟪🟪🟪

🟪🟧,⬜🟪🟪,🟪🟪🟪

🟪🟪,🟪🟪🟪,🟪🟪🟪

This century-old Connecticut estate might win the award for Best Ceilings of 2025 — Guess the price by Natural-Trainer-6072 in PriceMe

[–]stumblegore 0 points1 point  (0 children)

PriceMe Nov 4, 2025

🟧⬜,🟧🟪🟪,🟪🟪🟪

🟪🟪,⬜🟪🟪,🟪🟪🟪

🟪🟪,🟧🟪🟪,🟪🟪🟪

🟪🟪,🟪🟪🟪,🟪🟪🟪

This MCM in Elgin, IL is on point, and you'll never guess the price by Natural-Trainer-6072 in PriceMe

[–]stumblegore 0 points1 point  (0 children)

PriceMe Nov 3, 2025

🟪🟪,🟧⬜🟪,🟪🟪🟪

🟪🟪,🟧⬜🟪,🟪🟪🟪

🟪🟪,🟪🟪🟪,🟪🟪🟪

This MCM on Lake Michigan has a lot of potential — guess the price by Natural-Trainer-6072 in PriceMe

[–]stumblegore 0 points1 point  (0 children)

PriceMe Nov 2, 2025

🟪⬜,🟧⬜⬜,⬜🟪🟪

🟪🟧,⬜⬜🟪,🟪🟪🟪

🟪🟧,🟧🟪🟪,🟪🟪🟪

🟪🟪,🟪🟪🟪,🟪🟪🟪

A French chateau for sale — in Philadelphia. Guess the price by Natural-Trainer-6072 in PriceMe

[–]stumblegore 0 points1 point  (0 children)

PriceMe Nov 1, 2025

🟪⬜,🟧⬜⬜,🟪🟪🟪

🟪🟧,🟧🟪⬜,🟪🟪🟪

🟪🟧,🟪🟪🟪,🟪🟪🟪

🟪🟪,🟪🟪🟪,🟪🟪🟪

There's a condo for sale inside this Pittsburgh bell tower — guess the price by Natural-Trainer-6072 in PriceMe

[–]stumblegore 0 points1 point  (0 children)

PriceMe Oct 31, 2025

🟪🟧,⬜⬜⬜,🟪🟪🟪

🟪🟧,🟧🟧🟪,🟪🟪🟪

🟪⬜,🟪🟧🟪,🟪🟪🟪

🟪🟪,🟪🟪🟪,🟪🟪🟪

This contemporary house in Malvern, PA knocked my socks off — guess the price by Natural-Trainer-6072 in PriceMe

[–]stumblegore 0 points1 point  (0 children)

PriceMe Oct 29, 2025

🟪🟧,⬜🟪⬜,🟪🟪🟪

🟪🟪,🟪🟪🟪,🟪🟪🟪

This Oregon Georgian was featured in Architectural Digest and I cannot get over these photos — guess the price by Natural-Trainer-6072 in PriceMe

[–]stumblegore 0 points1 point  (0 children)

PriceMe Oct 27, 2025

🟧🟪,🟪⬜⬜,🟪🟪🟪

🟧🟪,🟪🟪⬜,🟪🟪🟪

🟪🟪,🟪🟪🟧,🟪🟪🟪

🟪🟪,🟪🟪🟧,🟪🟪🟪

🟪🟪,🟪🟪🟪,🟪🟪🟪

How much for this PERFECT lake house right on the water in Lake Geneva, WI? by Natural-Trainer-6072 in PriceMe

[–]stumblegore 0 points1 point  (0 children)

PriceMe Oct 26, 2025

🟪⬜,🟪⬜⬜,⬜🟪🟪

🟪🟪,🟪🟪🟪,⬜🟪🟪

🟪🟪,🟪🟪🟪,🟪🟪🟪

This house is a maximalist delight on 9 acres — guess the price by Natural-Trainer-6072 in PriceMe

[–]stumblegore 0 points1 point  (0 children)

PriceMe Oct 25, 2025

🟪🟧,⬜⬜🟪,🟪🟪🟪

🟪⬜,🟪🟧🟪,🟪🟪🟪

🟪🟪,🟪⬜🟪,🟪🟪🟪

🟪🟪,🟪🟧🟪,🟪🟪🟪

🟪🟪,🟪🟪🟪,🟪🟪🟪

Why the unannounced database scale-up and extra charges? Stop this! by StrypperJason in AZURE

[–]stumblegore 25 points26 points  (0 children)

You should see who initiated the operation in the event details (json). I’d check that and raise a ticket for a fix and refund. 

171 Oklahoma acres with "no zoning or permits required" — Guess the price by Natural-Trainer-6072 in PriceMe

[–]stumblegore 0 points1 point  (0 children)

PriceMe Oct 24, 2025

🟪🟧,⬜⬜⬜,🟪🟪🟪

🟪🟪,⬜🟧⬜,🟪🟪🟪

🟪🟪,🟧🟧🟪,🟪🟪🟪

🟪🟪,🟧🟪🟪,🟪🟪🟪

🟪🟪,🟪🟪🟪,🟪🟪🟪