[dba-SQLServer]Creating a new publication from a script

James Barash jbarash at bellatlantic.net
Wed Oct 29 15:13:14 CST 2003


Mark,
You should be able to run the script from the Query Analyzer. Open the
Query Analyzer on the new SQL Server, open the script file and click the
Execute button. That will build whatever the script file was created
for.
Hope that helps.

James Barash

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Mark
Boyd
Sent: Wednesday, October 29, 2003 3:11 PM
To: SQLServerList
Subject: [dba-SQLServer]Creating a new publication from a script


My company is in the process of replacing an old WinNT SQL Server with a
new Win2k SQL Server.

I need to re-create a number of publications on the new server.

I exported a script file with all of the properties from one of the
publications, but can't figure out how to create a new publication with
the data from this script file.

 

Any ideas?  Can this even be done, or do I have to manually re-create
the publications?

 

TIA,

Mark Boyd

Sr. Systems Analyst

McBee Associates, Inc.

 

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com



More information about the dba-SQLServer mailing list