Activity overview
Latest activity by MarioX
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...
Sync Tables with FileStream Column
We have problems to sync databases.
The sync-wizard give usw following message
[5538] Partial updates are not supported on columns that have a FILESTREAM as a source.
Any Idea how to sync tables wi...