I am new to SQL.
I successfully installed SQL server on a win10 PRO box at home.
I connected to a SQL server instance on my home machine.
I can create a database and work on it as described here:
However, I want to investigate an already created database from another machine at my office.
I want to be able to create custom reports from that data.
This other database is from an application that creates and manages a schedule.
It runs on a winPro box as well.
I have copied the DATA folder from that other machine running SQL server to the desktop of my home machine.
How do I open it ?
I tried a real noob thing--
Turned off sql server (in services) , replaced the DATA folder in here:
C:\Program Files\Microsoft SQL Server\MSSQL15.LYTEC_SQL\MSSQL\DATA
with the DATA folder I copied to the desktop.
Restarting sql server gives me an error.
Clearly I dont know what I am doing.
Is there a link somewhere that will explain to me what to do so I can start this other database to explore it (names of the fields,etc) and write reports?