Do all the things like ++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatarSign Up
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple APILearn More
Why not dockerize the db for local? 🤔
@SortOfTested It still needs to copy external database for that. Pretty slow. 1 week ago time for : Export production, deploy on local server was 8 minutes. (Around 3 GB database).
Now it’s done in 35 seconds.
I think I can do even better but I’m fighting bash at this point. I have “!!” in my password for prod DB, well, one of 2 thiongsa :
I need to encode it in bash
.Bet core can;’t accept these symbols
Sqlpackage utility can’t do ‘!!” in a password.
And I went with what I know : Hyper-V, Ubuntu (server 20 LTS), MS Sql server on linux and production databases are in Azure. (Azure Sync is shit and requires additional database (which you pay)).
So the flow will be : Each 2-3 nights a bacpac file is generated from prod and deployed to “Source DB” on local server. Then I have a script which can copy to another Tmp database. Which I use while developing and fucking up data. So the last step takes less than 30 secs, I can get ubder 15 I think.
@SortOfTested I can understand it. But right now I’m so happy, everything works.
The bizarre setup with Azure SQL, Windows server 2012, Hyper V, Ubuntu 20 LTS (as VM), Sql server on this Ubuntu and a snchro script.
And a small Storedproc to make a fast Db copy.
But yeah I lost like 30 mins on this “!!” thing in a password (and “ vs ‘).