UPDATE on SSISDB issue:

This was the error I'm getting:

TITLE: SQL Server Integration Services

------------------------------

The required components for the 64-bit edition of Integration Services cannot be found. Run SQL Server Setup to...

UPDATE:

With VS 2017 SSDT, uninstalling SSDT and reinstalling it (latest version standalone) adds SQL 2019.

SQL Server 2019 is supported starting from SSDT version 15.8.1. Doing an SSDT update...

• This reply was modified 4 years, 4 months ago by  ARPRINCE.

UPDATE:

• Looks like there is an issue with the SSISDB after migration. Long story but to make it short, we had a checklist  and someone did not do theirs and...

We did the cut-over yesterday and so far so good. Currently monitoring.

https://www.sqlservercentral.com/blogs/rename-or-change-sql-server-standalone-default-instance

After renaming the HOST and the SQL SERVER with default instance (used link above), I found that:

...

Thanks for the input and info on SP as well.

As it is right now, I took a SNAPSHOT of the 2019 server. Then I started migrating the 2014 - 2...

Yes, it would have made my life easier if there will no renaming. I wish that was a case. 🙁

Unfortunately, the SQL Server is referenced by applications running on an...

OK So I watched 2 youtube videos and below helped me setup what I need.

https://www.youtube.com/watch?v=pmTK5Um_9bw

In a nutshell, I did not follow my proposed steps 1&2. As with the...

SVR_A - Distributor/Publisher

SVR_B - Subscriber + SSRS

Yes I plan to do a lot of testing prior to.

• for the Sql Agent Job, just copy msdb?
• for SSRS, copy [ReportServer] and...

I added the last 2 lines on my STEP 3 below.

[3] ON SVR_A - DROP PUBLICATION

USE Published_DB;
EXEC sp_droppublication @publication = N'Published_DB_Publication';

USE master;
EXEC sp_replicationdboption @dbname = 'Published_DB', @optname...

It was a learning experience but over all, my project to rebuild our transactional replication from backup due to a system upgrade went very well. Other than the sp_dropsubscription part,...

PUSH (transactional), Distributor + Publisher = same server.

On the second subscription, I added last line below. Don't know if it would have a big impact though.

USE Published_DB;EXEC...

• This reply was modified 4 years, 8 months ago by  ARPRINCE.
• This reply was modified 4 years, 8 months ago by  ARPRINCE.

I just used sp_who2 and watched as it progressed. I didn't see any other SPID blocking the SPID I'm running. I did  see 1 or 2 other SPIDS being blocked...

So I decided to just wait until it finished. Took over 2.6 hours to drop 2 subscriptions. I simulated this on test environment with less powerful machines and it took...

Yes, the scripts removes all SQL agent replication jobs. I found out that you can remove the replication with the SQL AGENT SERVICE...

How is non-static data handled if you initialize via Snapshot?

For example, TABLE_A (10 records) gets a snapshot and is now on the snapshot folder.  TABLE_A gets updated, now has 12 records....