search

microsoft / DacFx

SQL Server database schema validation, deployment, and upgrade runtime. Enables declarative database development and database portability across SQL Server versions and environments.
https://aka.ms/sqlpackage-ref
MIT License
296 stars 16 forks source link

CREATE CERTIFICATE FROM BINARY #301

Open TorstenStrauss opened 12 months ago

TorstenStrauss commented 12 months ago

Steps to Reproduce:

  1. Add a sqlfile with Build Action 'Build' in SSDT with

CREATE CERTIFICATE ClrStrictSecurity FROM BINARY = 0x308203913082027DA003020102021013E6F73872521EAF490BB7D86C75CC2F300906052B0E03021D\ 05003048310B3009060355040613024445311D301B060355040A1314696E736964652D73716C7365\ 727665722E636F6D311A301806035504031311436C7253747269637453656375726974793020170D\ 3233303732333131303332395A180F32303939313233303232303030305A3048310B300906035504\ 0613024445311D301B060355040A1314696E736964652D73716C7365727665722E636F6D311A3018\ 06035504031311436C72537472696374536563757269747930820122300D06092A864886F70D0101\ 0105000382010F003082010A0282010100B319F909AC619D48CE00B0E3B9319163127A2456FCF21E\ EBD1620316CC387DA8AE8ACAE5084B5C94B8D2827E7CAEE94ABC8E324C99C74238E3B9002193D787\ C54D6B3D357D9B399F5AF696FC097CB60537842F16E007DFCD1613A240467E74EC5CED16C0DD8EE3\ B71A9975BC4C5F548A19AEB479A61754E51DE343943274753FF3C182457C5D8F1A96A751B15236C5\ F5B7BEB4811DA554642AA166B015DF7EF6FC44347738E8FFB00D3CA8103164416FED2E76D828FC53\ BD54697496FDE6F18DF892EA309A1906B1939CE6D29F704867CDD387497F789EA8401BCFFAE70F7F\ 865EF3A86C14A03AF9288516947365910B221005B812CCA33744E5A0CAD25062390203010001A37D\ 307B30790603551D010472307080100A6B6AF8F7D33BB8DE0AF0162400B5D2A14A3048310B300906\ 0355040613024445311D301B060355040A1314696E736964652D73716C7365727665722E636F6D31\ 1A301806035504031311436C725374726963745365637572697479821013E6F73872521EAF490BB7\ D86C75CC2F300906052B0E03021D050003820101007711A61A03705D55B7CDFC222EABA02C117174\ 1F9B21E79105563A0C66B7A5AB62DD2AC92F5CD9B8479EECFD27019FFCD13765DAD2AE1FC8209F20\ E4E4D45BD98FEE57259BB55645E7655DAF26B457161F7A26512CFE5276D19D71A7E26B4F1B2965DC\ C1C3DE03E8A6F0556F088A16C04FE4DE2EF958BB36002D0718E16216AA034F18F982926CE8666992\ 130C1B178D8D42930C7E46B0198A36106A369990F7FC506B2BE60CCE18B54782E6F518D6AF4D0D2F\ 93BD7D9B834CE3A0378A50D0B0DEBE9DE5861D1A6528E9AA1E6E4E530E2FC65C85C0D7DAD911EB5D\ B64AFCDC07554B9B0BD7818C480222005B2FC972F128885894CB7DF9A965B4D35B5B6CDF0D

  1. Building your project in SSDT will cause the error Error: SQL46005: Expected EXECUTABLE but encountered BINARY instead.

Did this occur in prior versions? If not - which version(s) did it work in? yes, I guess it had never worked. (DacFx/SqlPackage/SSMS/Azure Data Studio)

TorstenStrauss commented 12 months ago

Hi

The line break is only for better readability.

Making it all one line doesn't make a difference.

CREATE CERTIFICATE ClrStrictSecurity FROM BINARY = 0x308203913082027DA003020102021013E6F73872521EAF490BB7D86C75CC2F300906052B0E03021D05003048310B3009060355040613024445311D301B060355040A1314696E736964652D73716C7365727665722E636F6D311A301806035504031311436C7253747269637453656375726974793020170D3233303732333131303332395A180F32303939313233303232303030305A3048310B3009060355040613024445311D301B060355040A1314696E736964652D73716C7365727665722E636F6D311A301806035504031311436C72537472696374536563757269747930820122300D06092A864886F70D01010105000382010F003082010A0282010100B319F909AC619D48CE00B0E3B9319163127A2456FCF21EEBD1620316CC387DA8AE8ACAE5084B5C94B8D2827E7CAEE94ABC8E324C99C74238E3B9002193D787C54D6B3D357D9B399F5AF696FC097CB60537842F16E007DFCD1613A240467E74EC5CED16C0DD8EE3B71A9975BC4C5F548A19AEB479A61754E51DE343943274753FF3C182457C5D8F1A96A751B15236C5F5B7BEB4811DA554642AA166B015DF7EF6FC44347738E8FFB00D3CA8103164416FED2E76D828FC53BD54697496FDE6F18DF892EA309A1906B1939CE6D29F704867CDD387497F789EA8401BCFFAE70F7F865EF3A86C14A03AF9288516947365910B221005B812CCA33744E5A0CAD25062390203010001A37D307B30790603551D010472307080100A6B6AF8F7D33BB8DE0AF0162400B5D2A14A3048310B3009060355040613024445311D301B060355040A1314696E736964652D73716C7365727665722E636F6D311A301806035504031311436C725374726963745365637572697479821013E6F73872521EAF490BB7D86C75CC2F300906052B0E03021D050003820101007711A61A03705D55B7CDFC222EABA02C1171741F9B21E79105563A0C66B7A5AB62DD2AC92F5CD9B8479EECFD27019FFCD13765DAD2AE1FC8209F20E4E4D45BD98FEE57259BB55645E7655DAF26B457161F7A26512CFE5276D19D71A7E26B4F1B2965DCC1C3DE03E8A6F0556F088A16C04FE4DE2EF958BB36002D0718E16216AA034F18F982926CE8666992130C1B178D8D42930C7E46B0198A36106A369990F7FC506B2BE60CCE18B54782E6F518D6AF4D0D2F93BD7D9B834CE3A0378A50D0B0DEBE9DE5861D1A6528E9AA1E6E4E530E2FC65C85C0D7DAD911EB5DB64AFCDC07554B9B0BD7818C480222005B2FC972F128885894CB7DF9A965B4D35B5B6CDF0D

GO

Viele Grüße

Torsten Strauß

From: asrichesson @.> Sent: Thursday, 27 July 2023 08:27 To: microsoft/DacFx @.> Cc: Torsten Strauß @.>; Author @.> Subject: Re: [microsoft/DacFx] CREATE CERTIFICATE FROM BINARY (Issue #301)

you have to make the statement all a single line CREATE CERTIFICATE ClrStrictSecurity FROM BINARY = 0x308203913082.....

— Reply to this email directly, view it on GitHub https://github.com/microsoft/DacFx/issues/301#issuecomment-1652985694 , or unsubscribe https://github.com/notifications/unsubscribe-auth/ALSGU4QAS2IAX7L2KHKMJNTXSIC23ANCNFSM6AAAAAA2WWCOMU . You are receiving this because you authored the thread. https://github.com/notifications/beacon/ALSGU4WCYOK43PYSAOUN7GDXSIC23A5CNFSM6AAAAAA2WWCOMWWGG33NNVSW45C7OR4XAZNMJFZXG5LFINXW23LFNZ2KUY3PNVWWK3TUL5UWJTTCQ2HV4.gif Message ID: @. @.> >