AdventureWorks2017 vs. AdventureWorksDW2017

Question

I wonder what the difference is between the 2 databases in the title? I installed successfully AdventureWorks2017. I can see all tables and open up the records. It is a very useful tool. However, I cannot fill the other database: warehouse. The way the restoration worked for me was that I got the headings in the Object Explorer but no tables at all, I mean no file tables. Even the system tables are absent, only one is there. I tried to restore the DW database a couple of times with proper options and after a few fails, it finally said that the database restored successfully. Successfully in what sense? Still there are no tables.

Please explain what the DW database is. Perhaps I don't need it at all.

Thanks, - MyCatAlex

Answer 1

There is no relationship between AdventureWorks and AdventureWorksDW.  They are different databases used for different purposes and examples.

Answer 2

Not enough for me to mark your post as an answer. I need to know more about AdventureWorksDW2017.

Answer 3

OK, I now know the difference between AdventureWorksDW and AdventureWorks

OLAP, OPTP

however I still don't know why I cannot get any data in DW when the restore process tells me that the database DW was restored successfully.

- MyCatAlex

Answer 4

Hi Friend, 

You can read about this in : 

AdventureWorks Database

or 

SQL SERVER – What is AdventureWorks?

---

If this answer has helped you, mark it helpful so that someone else with a question or similar problem can find an answer or help more easily. Jefferson Clyton Pereira da Silva - [MCSA | MCP | MCTS | MTA | Database Analyst - Sql Server and Oracle]

Answer 5

Hi Friend, 

You can read about this in : 

AdventureWorks Database

or 

SQL SERVER – What is AdventureWorks?

---

If this answer has helped you, mark it helpful so that someone else with a question or similar problem can find an answer or help more easily. Jefferson Clyton Pereira da Silva - [MCSA | MCP | MCTS | MTA | Database Analyst - Sql Server and Oracle]

I don't download anything that it not Microsoft authored.The top of the page must say Microsoft.

- MyCatAlex

Answer 6

however I still don't know why I cannot get any data in DW when the restore process tells me that the database DW was restored successfully.

- MyCatAlex

Can you drop the existing AdventureWorksDW2017 and restore the backup again. 

Also post the screenshot where you see only DB but no tables.

I downloaded AdventureWorksDW2017.bak from here and restored it. I can see the tables. 

---

Regards,
Vaibhav