Search
-
Re: Command-line SQL compare breaks FileStream - but not GUI
Comment by Brian Donahue · · Home› Discontinued and Previous Versions› SQL Compare Previous VersionsProduced by command-line:/*Run this script on: XXX\sql2008r2.50855-B - This database will be modifiedto synchronize it with: XXX\sql2008r2.50855-AYou are recommended to back up your database before running this scriptScript created by SQL Compare version 9.0.0 from Red Gate Software Ltd at 23/08/2011 14:57:40*/SET… -
Command-line SQL compare breaks FileStream - but not GUI
I have a table with a FileStream blob field and a PK Guid ID, declared thusly: CREATE TABLE [dbo].[MyTable]( [Id] [uniqueidentifier] ROWGUIDCOL NOT NULL, [Data] [varbinary](max) FILESTREAM NULL,CONSTRAINT [PK_MyTable] PRIMARY KEY CLUSTERED ( [Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY =…
2 results