How to sync local source control folders on new laptop?

krshort · August 10, 2017 1:17PM

I recently had a drive crash on my laptop. I'm using a different machine for now, but discovered that after I re-linked to my dev DB (shared model), the objects I created are not correctly displayed in SSMS. In particular, new objects that I created but not yet checked in. I've looked for a document on how to sync my local folders to a shared model. I only have a few objects to sync, and could do it manually if I knew how. Are there any instructions available for this scenario?

AlexYates · August 10, 2017 1:21PM

What source control system are you using? Can I assume you were using a git repo on the local machine (and that local repo was lost)?

Is there a remote repo involved somewhere? On a server somewhere or in the cloud perhaps?

krshort · August 10, 2017 1:26PM

Thanks for your quick response. I am on TFS. The relink re-created my working and transient folders, but my new objects do not show as belonging to me. They exist on the shared model DB, of course, but I can't check them in to source control from the new laptop.

David Atkinson · August 10, 2017 1:34PM

@krshort Does it matter that they aren't shown as belonging to you? Can't you select them anyway and check them in?

krshort · August 10, 2017 1:37PM

No. When I select 'commit changes', the objects in question do not show up on the list.

AlexYates · August 10, 2017 1:41PM

You can use SQL Compare Pro to compare your database to a set of folders and to update them. You can set scripts folder as either the source or target.

https://documentation.red-gate.com/display/SC12/Working+with+scripts+folders

Are you using TFGit or TFVC? If you are using TFGit you can just use SQL Compare to update your local repo based on the DB version and commit/push. That should sort ouut your sync issues.

If using TFVC I cannot remember off the top of my head where the Git checkout gets mapped to and whether this will work. David or one of the dev team can probably help.

AlexYates · August 10, 2017 1:42PM

*Note, for my suggestion with Git it's probably simplest to commit/push with whatever git client you normally use. Whether that's Git Bash, SourceTree or something else.

krshort · August 10, 2017 2:21PM

Unfortunately we have not migrated to GIT yet, it is a project slated for 2018 Q1. Let me review the doc you referenced and see if I can figure out how to get my folders in sync. Thanks again.

How to sync local source control folders on new laptop?

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk