You can change the primary database to a replicate database.
At the:
Current replicate Replication Server.
Drop all subscriptions and
publication subscriptions to the replication definitions in this
database.
Current primary Replication Server.
Drop all replication definitions
defined for this database.
Adaptive Server.
Shut down RepAgent:
sp_stop_rep_agent dbname
Disable RepAgent:
sp_config_rep_agent dbname, disable
Replication Server
Log in to the Replication
Server that manages the database and execute alter connection using
the log transfer off option:
alter connection to data_server.database
set log transfer off
Adaptive Server
Set the status of rs_marker to “false:”
sp_setrepproc rs_marker, 'false'
Set the replicate status of all replicated objects
to “false”:
Execute sp_setreptable
and
sp_setrepproc without arguments to
generate a list of all replicated tables and stored
procedures respectively, in the database.
One by one, set the replicate status of each table
and stored procedure to “false,” using sp_setreptable and sp_setrepproc.