Activity overview
Latest activity by Danr
@Kendra_Little Thanks for your update. Let's assume we would change our database. Tables with > 100k rows would be merged and converted to JSON and appended to about 5000 records. Would this perform better or would Source Control need more time to compare the strings which would end up with the same result? For example we have a table cars (5k records) and a table carparts (> 100k records). We could describe the carparts of each car with a json and then we could add that as a column in the cars table. / comments
@Kendra_LittleThanks for your update.Let's assume we would change our database. Tables with > 100k rows would be merged and converted to JSON and appended to about 5000 records.Would this perform b...
@Kendra_Little so if I understand that correctly, seed data means that we have something like an initial state for the static data (provided by a csv file for example) and after that SQL Source Control can handle changes of 500-1000 rows per Branch easily? But what when some of the initial data will be changed (deleted or updated) is that also working? / comments
@Kendra_Little so if I understand that correctly, seed data means that we have something like an initial state for the static data (provided by a csv file for example) and after that SQL Source Con...
Is SQL Source Control able to manage static data in tables with ~200k rows
Hi there,I need a tool to manage static data in a database. We have some very big tables with around 200k rows. When we develop features in a feature branch we want to commit the changes in the dat...
@Russell D I also need to filter my static data with a where statement. I need all static data in a table where a specific column is null and push them to git. Is this possible with the change automation filters? @PeterDaniels , @matpez Did you found any solution? / comments
@Russell D I also need to filter my static data with a where statement. I need all static data in a table where a specific column is null and push them to git. Is this possible with the change auto...
Combine Seed Data + Migration Scripts
Hi,I have a table with > 100.000 rows. Is it possible to use seed data to get the initial state and then continue using the table with migration scripts? I tried to achieve this, but when I add the...