[DiscordArchive] is it though?
[DiscordArchive] is it though?
![[Image: image.png?ex=690c1552&is=690ac3d2&hm=ea8...14a2aa8c2&]](https://cdn.discordapp.com/attachments/415944535718494208/1263879568872312934/image.png?ex=690c1552&is=690ac3d2&hm=ea82d17d58f9a3aaf5ec693c7a7eec7d9f9343663907defec09d57314a2aa8c2&)
Archived author: tester • Posted: 2024-07-19T15:26:11.013000+00:00
Original source
also diffing an entire tc db for me took about 6 seconds. so not sure compute time is really a worry here
![[Image: image.png?ex=690c1552&is=690ac3d2&hm=ea8...14a2aa8c2&]](https://cdn.discordapp.com/attachments/415944535718494208/1263879568872312934/image.png?ex=690c1552&is=690ac3d2&hm=ea82d17d58f9a3aaf5ec693c7a7eec7d9f9343663907defec09d57314a2aa8c2&)
Archived author: Foe • Posted: 2024-07-19T15:26:14.331000+00:00
Original source
if your approach between the two deviates, then you don't have any form of assurance that it will actually work properly
Archived author: tester • Posted: 2024-07-19T15:26:32.017000+00:00
Original source
the data match is arguably what would break it, not the difference in a version tracking
Archived author: Foe • Posted: 2024-07-19T15:28:16.245000+00:00
Original source
but you could input data manually right, now you export a query and you assume that the query works properly. in many cases it probably will, but it's not a given, depending on db version, db engine, collation, etc
Archived author: Foe • Posted: 2024-07-19T15:28:47.734000+00:00
Original source
you're 100% at the mercy of the tool you are using to generate the queries, and you haven't tested those queries
Archived author: Foe • Posted: 2024-07-19T15:28:53.644000+00:00
Original source
this is super bad practice to push to live
Archived author: tester • Posted: 2024-07-19T15:29:11.278000+00:00
Original source
why would db version/engine/collation not all match?
Archived author: tester • Posted: 2024-07-19T15:29:21.871000+00:00
Original source
if they're mirrored dbs, you're only questioning data
Archived author: Foe • Posted: 2024-07-19T15:29:59.525000+00:00
Original source
I can guarantee you that the majority of people doing this don't ensure that they are using the exact same settings and versions between dev and live
Archived author: tester • Posted: 2024-07-19T15:30:17.729000+00:00
Original source
this is my fantasy land, i get to make the rules