Vantage 8.03 on MSSQL 2005.
I want to create a read-only replication of my GL data at a remote
site for some reporting needs.
Vantage's MSSQL schema doesn't have PKs defined in-schema so
transactional replication won't work in MSSQL.
Merge replication wants to add a new ROWGUID column to act as a unique
identifier, and says the following.
Will this break Vantage?
Has anyone set this up for a similar purpose (off-loading reporting to
another server/remote site) and if so how do you do it safely?
-bws
All merge articles must contain a uniqueidentifier column with a unique
index and the ROWGUIDCOL property. SQL Server adds a uniqueidentifier
column to published tables that do not have one when the first snapshot
is generated.
Adding a new column will:
the ROWGUIDCOL property to each of the following tables.
[dbo].[company]
[dbo].[glchart]
[dbo].[gldept]
[dbo].[gldiv]
[dbo].[gljrndtl]
[dbo].[gljrngrp]
[dbo].[gljrnhed]
[dbo].[gljrnhedext]
[dbo].[gljrnsrc]
[dbo].[glopnbal]
[dbo].[glperbal]
[dbo].[glratype]
[dbo].[glrecdtl]
[dbo].[glreched]
[dbo].[glrefact]
[dbo].[glrefcod]
[dbo].[glreftyp]
--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
bspolarich@...
<mailto:bspolarich@...> ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>
[Non-text portions of this message have been removed]
I want to create a read-only replication of my GL data at a remote
site for some reporting needs.
Vantage's MSSQL schema doesn't have PKs defined in-schema so
transactional replication won't work in MSSQL.
Merge replication wants to add a new ROWGUID column to act as a unique
identifier, and says the following.
Will this break Vantage?
Has anyone set this up for a similar purpose (off-loading reporting to
another server/remote site) and if so how do you do it safely?
-bws
All merge articles must contain a uniqueidentifier column with a unique
index and the ROWGUIDCOL property. SQL Server adds a uniqueidentifier
column to published tables that do not have one when the first snapshot
is generated.
Adding a new column will:
> Cause INSERT statements without column lists to failSQL Server will add a uniqueidentifier column with a unique index and
> Increase the size of the table
> Increase the time required to generate the first snapshot
the ROWGUIDCOL property to each of the following tables.
[dbo].[company]
[dbo].[glchart]
[dbo].[gldept]
[dbo].[gldiv]
[dbo].[gljrndtl]
[dbo].[gljrngrp]
[dbo].[gljrnhed]
[dbo].[gljrnhedext]
[dbo].[gljrnsrc]
[dbo].[glopnbal]
[dbo].[glperbal]
[dbo].[glratype]
[dbo].[glrecdtl]
[dbo].[glreched]
[dbo].[glrefact]
[dbo].[glrefcod]
[dbo].[glreftyp]
--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
bspolarich@...
<mailto:bspolarich@...> ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>
[Non-text portions of this message have been removed]