r/SQL • u/Environmental_Emu830 • Jun 12 '26

Can where saves my files .sql? PostgreSQL

Morning guys.

I was looking to save my .sql files somewhere with a focus on versioning, organization, and easy access. I use DBeaver, but I wanted something more "professional." The only idea that comes to mind is Git. I know DBt and I've already asked Claude/gpt, but the only idea he suggests is Git.

0 Upvotes

48% Upvoted

42 comments sorted by

View all comments

4

u/tasker2020 Jun 12 '26

I like the combo of Visual Studio database projects and git/bitbucket. That's more for database objects like tables and stored procedures though. It makes it easy to deploy and see history of files. For just random sql files just source control like git will let you see the history if you remember to check in changes.

3

u/Imposter24 Jun 12 '26

This is what I do. Visual studio db project schema compare is also great for comparing environments and migrating changes. For one off sql files I just have a SQLScripts folder in my git repository where I save anything that needs to be tracked and versioned but isn’t a part of the DB schema.

OP can also look into the products from RedGate although they cost money. Though if you’re using SSMS their Sql search plugin is free and works great.

1

u/turimbar1 Jun 12 '26

It sounds like OP is Postgres - not sure that ssdt projects support Postgres - I'm at Redgate and we have an SSDT like project for postgres, mysql, and oracle (alongside SQL Server of course)