August 29, 2018 at 4:51 am
Using SSMS v17.8.1, I'm scripting my Replication PUBS which reside on a SQL 2014 Enterprise server. (to save as a backup)
- right mouse click PUB name
- Generate scripts...
- Select Radio Button: To create or enable the components
- File format: Windows text (ANSI)
- Generate Script -- Open in New Query Window
1st question: Is 'File format': Windows text acceptable -- or should I be selecting 'International text (Unicode)?
2nd question: On the 'Generate SQL Script' box, the check box 'Replication jobs' is grayed out. Is this normal? Are the jobs dyamically created if I rung the scripts on my D/R box?
thx in advance
September 4, 2018 at 8:18 am
Express12 - Wednesday, August 29, 2018 4:51 AMUsing SSMS v17.8.1, I'm scripting my Replication PUBS which reside on a SQL 2014 Enterprise server. (to save as a backup)- right mouse click PUB name
- Generate scripts...
- Select Radio Button: To create or enable the components
- File format: Windows text (ANSI)
- Generate Script -- Open in New Query Window1st question: Is 'File format': Windows text acceptable -- or should I be selecting 'International text (Unicode)?
2nd question: On the 'Generate SQL Script' box, the check box 'Replication jobs' is grayed out. Is this normal? Are the jobs dyamically created if I rung the scripts on my D/R box?
thx in advance
The format depends on if you are using unicode characters for objects used in replication. Only you can answer that one.
It is normal for the Replication jobs checkbox to be greyed out if this is a push subscription. It's enabled for pull subscriptions
With push subscriptions, The jobs are created towards the end of the script in the Adding the transactional subscriptions section - look for sp_addpushsubscription_agent
With pull subscriptions, there will be scripts to run at the subscriber which include sp_addjob, sp_addjobstep, etc.
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply