Pulse Database Migration from SQL Server on Prem to AWS RDS

Hi

One of our client is setting up Pulse on their new AWS PA Server and using AWS RDS as the Pulse DB.

However, they currently have 8GB worth of Pulse historical database in their current on Prem SQL Server.

What is the best way to migrate the data from SQL Server on Prem to AWS RDS?

Apparently a traditional restore database file approach isn’t possible on RDS and importing via script isn’t working too well for a 8GB database.

Hi @Sb5,

I believe your question goes beyond the Pulse as product itself and rather , I suggest to follow Amazon’s procedure, this has its variants by database, but according to Amazon’s documentation [1] and [2] is completely possible.

Now, once the database is on SQL Server RDS[1] the only thing to do from the Pulse side is to configure the SQL server connection in the Pulse.cfg.

[1] https://aws.amazon.com/premiumsupport/knowledge-center/rds-import-data/ (browsed on Sept, 2019)

[2] https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.html (browsed on Sept, 2019)

Best Regards,

Erik

Thanks @ecarmona

I will pass on this info to the client’s Server Engineering team.

Hi @ecarmona

How about trimming the Pulse database? Are there any tools that come along as part of the install to do that?

Or would this just be reliant on the client’s DBA?

Thanks

Hi @Sb5

For non default Pulse databases, I believe yes - one would be reliant on the client DBA.
(for the default H2 database one can access it via the browser with the right user credentials)

Can you maybe give some more detail on what the client wants to target?
E.g. does the client want to remove data prior to a specific point in time?
Or maybe target specific entities/years etc.?

Thanks

Hi @Sb5,

complementing @gpool 's answer, you can also look at the maintenance Job:

Regards,

Erik

HI @ecarmona

Just want to clarify. This maintenance job is only available if we were to use the default H2 database right?

Hi @Sb5,

No, the maintenance job is for both databases, SQL server and H2.

Regards,

Erik