Package scripts created with SQL Compare/SQL Data Compare

mlukas

Can I use SQL Packager to package scripts that I created with SQL Compare and SQL Data Compare? I want to add in extra steps to the scripts beyond what SQL Packager itself will generate.

Brian Donahue

Hello,

Unfortunately you can't plug SQL Scripts into SQL Packager. What you could do is save the package as a C# project and edit the project in Visual Studio, adding your SQL Scripts to the project, either an embedded resource or in the PackageExecutor code, then compile the packager project.

mlukas

Any thought to adding this functionality in a future version? It's far easier to edit and test the scripts outside of Visual Studio.

Brian Donahue

Hi,

Yes, because it is requested very often. But in the Beta of version 5, it's still not in there.