Comments
Sort by recent activity
Many thanks for your time.
Short info:
Its possible to sync filestream columns with the sync tool from MS (included in the SQL Server Tools).
Its a little bit tricky and not very comfortable but it works. / comments
Many thanks for your time.
Short info:
Its possible to sync filestream columns with the sync tool from MS (included in the SQL Server Tools).
Its a little bit tricky and not very comfortable but it...
ok, script to large for a forum post [image]
Here you can find the generated script from DataCompare http://aterp.de/SyncTableWithFileStreamColumn.sql
And here you can find a test database, includes
- a test DB with one row
- a empty DB
- DataCompare Sync File http://aterp.de/TestDatabases.rar / comments
ok, script to large for a forum post
Here you can find the generated script from DataComparehttp://aterp.de/SyncTableWithFileStreamColumn.sql
And here you can find a test database, includes
- a t...
Thanks for the answer.
Where can I find infos about SDC-909?
With the Import / Export Tool from Microsoft its possible to sync Tables with FileStream Column. Unfortunately the tool doesn't show the SQL script ;-)
Table Design
USE [IRLDatabasePrepared]
GO
/****** Object: Table [dbo].[FileStore] Script Date: 02/18/2010 23:38:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[FileStore](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Filename] [nvarchar](256) NOT NULL,
[Size] [nvarchar](256) NOT NULL,
[Date] [datetime] NOT NULL,
[MimeType] [nvarchar](256) NULL,
[Title] [nvarchar](256) NULL,
[IRLComment] [text] NULL,
[FileRefCount] [int] NOT NULL,
[FileRefs] [xml] NULL,
[RowGuid] [uniqueidentifier] ROWGUIDCOL NOT NULL,
[Blob] [varbinary](max) FILESTREAM NOT NULL,
PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] FILESTREAM_ON [FileStreamGroup1],
UNIQUE NONCLUSTERED
(
[RowGuid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] FILESTREAM_ON [FileStreamGroup1]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[FileStore] ADD CONSTRAINT [DF_FileStore_FileRefCount] DEFAULT ((0)) FOR [FileRefCount]
GO
ALTER TABLE [dbo].[FileStore] ADD DEFAULT (newid()) FOR [RowGuid]
GO / comments
Thanks for the answer.
Where can I find infos about SDC-909?
With the Import / Export Tool from Microsoft its possible to sync Tables with FileStream Column. Unfortunately the tool doesn't show the...