Using SQL lite for multiple Devs
# help-with-umbracot
TigerMan
09/02/2024, 9:07 AMHi
I am testing theories to see what fits our scenario the best.
I have created a test website (Umbraco 13) installed uSync and using SQL lite.
I push this to the repo but when pulling this from another PC I don't have the SQL lite database created or pushed in.
Should I be pushing this file residing under the data directory to the repo?
Or is there another way to create this file manually and then import using uSync?
Thank you in advance
m
Mike Chambers
09/02/2024, 9:09 AMsee ->
unattended installMike Chambers
09/02/2024, 9:11 AMor Usync first boot.. might be a better fit.. https://docs.jumoo.co.uk/usync/uSync/guides/firstboot
Mike Chambers
09/02/2024, 9:11 AMBut I'd say don't add the DB to the repo... 🙂
Mike Chambers
09/02/2024, 9:15 AMt
TigerMan
09/02/2024, 9:24 AMThank you, uSync seems to be set correctly as far as I can tell and I agree with the DB content so leaves me with the unattended install.
If I enable this setting in the setting config and I correct in understanding this stuff prompt me to install a local SQL lite database and then uSync should take care of the rest?
b
Bram
09/02/2024, 9:28 AMWe're also using usync with local SqlLite databases and on the first boot (after cloning the repo) we just empty the connection string once. This will trigger an install after which the settings that Mike specified will trigger all content and settings
m
Mike Chambers
09/02/2024, 9:32 AMIt doesn't prompt.. if it can't find the sqllite DB (you'll see in the logs it tries to connect 4 times..) and then as you have unattended set it will go off and install the DB for you
Mike Chambers
09/02/2024, 9:36 AMuSync first boot.. might be a little more of a timesaver.. though depends how you have uSync set up.. we only have uSync track Settings.. (not content and media) and if you are using standard uSync for content and media then the import at startup process could be lengthy each time.. where as AFAIK uSync firstBoot can we set up to do the content/media and then standard usync back to just settings..
2 Views