tag:blogger.com,1999:blog-7476247.post7063619503644491730..comments2024-03-19T12:27:57.831+00:00Comments on Steven Wright Blog: Integrating tsqlt with SQL Server Data ToolsSteve Wrighthttp://www.blogger.com/profile/15679255693378492813noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-7476247.post-8989198626906339542015-04-12T21:43:05.262+02:002015-04-12T21:43:05.262+02:00Hi Greg
When using SQLPackage to export the tsq...Hi Greg<br /> When using SQLPackage to export the tsqlt database there should have been a DLL file eported as well. This DLL file needs to be copied the DACPAC as well. <br /><br />Regards<br />SteveSteven Wrighthttps://www.blogger.com/profile/10250648827790297322noreply@blogger.comtag:blogger.com,1999:blog-7476247.post-20904050683880853922015-04-07T03:14:59.864+02:002015-04-07T03:14:59.864+02:00Hi, I'm trying to export the .dacpac and while...Hi, I'm trying to export the .dacpac and while that appears to work, when I make the reference, it is complaining that the associated .dll isn't found. Are there extra steps needed to included the CLR stored procedures in the .dacpac? <br />Thanks!<br />GregAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7476247.post-32047371560567710752014-09-06T00:42:01.651+02:002014-09-06T00:42:01.651+02:00Excellent, thank you! Got this set up and working ...Excellent, thank you! Got this set up and working now, and I had forgotten about the 'Include Composite Projects' check since I initially set up my solution.<br /><br />Thanks,<br />Lee AnneAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7476247.post-28602117271939331882014-09-05T12:23:44.556+02:002014-09-05T12:23:44.556+02:00Hi Lee Anne, You will need to ensure that the tsql...Hi Lee Anne, You will need to ensure that the tsqlt.dacpac is added into source control. <br /><br />The way I handle this was to create a Solution folder call Reference then added the tsqlt.dacpac file. This will then allow Visual Studio to download the file when you, or someone else, does a Get Latest at the solution file level. <br /><br />When Comparing the project against a target database you will need to set the following option: Include Composite Objects which is under General Tab. This will make the compare treat References as part of project and compare them against the target database update/create/delete as appropriate. <br /><br />For more information about Reference here is a link: http://msdn.microsoft.com/en-us/library/jj684584(v=vs.103).aspx<br /><br />Regards<br />SteveSteven Wrighthttps://www.blogger.com/profile/10250648827790297322noreply@blogger.comtag:blogger.com,1999:blog-7476247.post-29344370799985625702014-09-04T22:59:02.146+02:002014-09-04T22:59:02.146+02:00Visual Studio noob here. Do you have to do anythin...Visual Studio noob here. Do you have to do anything with the .dacpac after making a reference to it? Does it magically end up in source control somehow, or does it need to be manually added to the project?<br /><br />After adding the reference, I did a compare between the new tSQLt database project and the database that I created the .dacpac from, and the project wanted to delete all the non-existent objects from the database. Perhaps you can also point me to some pages that explain how to work with .dacpacs as references?<br /><br />Thanks,<br />Lee AnneAnonymousnoreply@blogger.com