Skip to content

Latest commit

 

History

History
92 lines (62 loc) · 3.51 KB

sp-vupgrade-replication-transact-sql.md

File metadata and controls

92 lines (62 loc) · 3.51 KB
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs
sp_vupgrade_replication (Transact-SQL)
Activated by setup when upgrading a replication server.
markingmyname
maghan
randolphwest
11/02/2023
sql
replication
reference
sp_vupgrade_replication_TSQL
sp_vupgrade_replication
sp_vupgrade_replication
TSQL

sp_vupgrade_replication (Transact-SQL)

[!INCLUDE SQL Server SQL MI]

Activated by setup when upgrading a replication server. Upgrades schema and system data as needed to support replication at the current product level. Creates new replication system objects in system and user databases. This stored procedure is executed at the machine where the replication upgrade is to occur.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

sp_vupgrade_replication
    [ [ @login = ] N'login' ]
    [ , [ @password = ] N'password' ]
    [ , [ @ver_old = ] ver_old ]
    [ , [ @force_remove = ] force_remove ]
    [ , [ @security_mode = ] security_mode ]
    [ , [ @db_id = ] db_id ]
[ ; ]

Arguments

[ @login = ] N'login'

The system administrator login to use when creating new system objects in the Distribution database. @login is sysname, with a default of NULL. This parameter isn't required if @security_mode is set to 1, which is Windows Authentication.

Note

This parameter is ignored when you're upgrading to [!INCLUDE ssVersion2005] and later versions.

[ @password = ] N'password'

The system administrator password to use when creating new system objects in the Distribution database. @password is sysname, with a default of an empty string. This parameter isn't required if @security_mode is set to 1, which is Windows Authentication.

Note

This parameter is ignored when you're upgrading to [!INCLUDE ssVersion2005] and later versions.

[ @ver_old = ] ver_old

[!INCLUDE ssInternalOnly]

This stored procedure is deprecated and will be removed in a future release of [!INCLUDE ssNoVersion].

[ @force_remove = ] force_remove

[!INCLUDE ssInternalOnly]

[ @security_mode = ] security_mode

The login security mode to use when creating new system objects in the Distribution database. @security_mode is bit, with a default of 1. If 0, [!INCLUDE ssNoVersion] Authentication is used. If 1, Windows Authentication is used.

Note

This parameter is ignored when you're upgrading to [!INCLUDE ssVersion2005] and later versions.

[ @db_id = ] db_id

[!INCLUDE ssInternalOnly]

Return code values

0 (success) or 1 (failure).

Remarks

sp_vupgrade_replication is used when upgrading all types of replication.

Permissions

Only members of the sysadmin fixed server role can execute sp_vupgrade_replication.

Related content