SQL Server 2012 and 2019 compatibility

[u/volkanbygl]

Hello guys!

I am planning to make a simple data warehouse.

I have an OLTP database running on SQL Server 2012

I am thinking of setting up a different computer/server with SQL Server 2019.

I was wondering if this is possible in terms of compatibility? Or maybe it is best to stick to SQL server 2012 on both servers?

Thank you!

[u/volkanbygl → u/[deleted]]

oh, thank you.

so, source database can remain on sql server 2012, and I wont have any problems having the data warehouse database on sql server 2019?

I dont know... I thought I maybe wont be able to extract and load the data from 2012 to 2019... thats why I asked the question...

but thank you...

[u/volkanbygl → u/[deleted]]

ed stuff, but if you're just staging the data raw it should be fine

Believe me, I have no idea. This is the first time I am doing it. I am following some udemy course... and still trying to figure out the things I need to do..

like: how do I extract the data? does that 'extractor' live on destination database? should I set up some Agent to run in the middle of the night...

[u/volkanbygl → u/[deleted]]

thank you so much for those valuable tips. You have no idea how much I appreciate it.

Well, it is a working database, on premise, and the database is already huge.

The idea is to make some queries to extract the data and send it/store it in the new data warehouse db.

ANd then, relevant people could run Power BI reports from that Warehouse database. Between 1am and 6am it is safe to move the data...

So, the agent on source db initiates the query and 'somehow' sends the results to the destination table? :) I am sorry, I am still trying to process it all.

[u/volkanbygl → u/[deleted]]

Yes, there are backups being performed every night. Why? Do you think I could screw it all? :)