How Do I Export And Import Jobs From SQL Compare From One Server To Another

seeker5cs · April 7, 2020 4:06PM

I am using SQL Compare 10.7 on Windows Server 2008. I need to export the jobs that are currently located on that server and after the new server is set up, I need to import the jobs to the new version.

David Atkinson · April 7, 2020 4:35PM

@seeker5cs - Ah. Then it's just a question of moving the .scp files to the new server. Mine are in C:\Users\david.atkinson\Documents\SQL Compare\SharedProjects but in SQL Compare if you click on My Projects you'll see the path of the projects you've last used at the top of the dialog.

David Atkinson · April 7, 2020 4:19PM

@seeker5cs - Sorry, Jobs aren't supported in SQL Compare. Please vote for this on Uservoice!

seeker5cs · April 7, 2020 4:21PM

So, if we set up a new server, all the current sql comparisons that we have on the existing server need to be rebuilt?

David Atkinson · April 7, 2020 4:23PM

@seeker5cs - What do you mean by jobs? I assumed you meant Server Agent Jobs. Do you mean SQL Compare projects? If you do, these are just files with the.scp extension that you can copy across.

seeker5cs · April 7, 2020 4:28PM

Yes, forgive my incorrect wording. I am looking to export the SQL Compare projects that we currently have set up on the old server and then move/import them on the new server. Thank you

How Do I Export And Import Jobs From SQL Compare From One Server To Another

Best Answer

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk