How to import existing project

DenBio00

I have what I believe is a RedGate source control project on disk here, and I want to recreate the database on SQL Server from it. I am having trouble finding how to do that exactly, so any help would be appreciated.

The folder has a Filter.scpf, RedGate.scc and RedGateDatabaseInfo.xml files, and folder structure of Assemblies, Data, Database Triggers etc.

Probably I am missing a concept or two in between here?

Evan Moss

Hello,

Thanks for your post.

That does seem like a source control scripts folder. You should be able to use SQL Compare with that folder as a source to create a new database with the same objects. To do this, you'll select the "source control" radio button in the project settings, then select "scripts folder" and put in the path to your folder. On the target side, select "database", then specify a SQL instance and choose "Create Database".

In theory, you might be able to achieve the same thing in SQL Source Control by linking a blank database to that folder and doing a "get latest", but that's not recommended and is a lot clumsier to troubleshoot.

Hope that helps.

Thanks,
Evan

DenBio00

Hi Evan,

Yup, that works. Thank you for your time and support.

Regards, Denis