...
Open Microsoft SQL Management Studio and start a connection to the database server. This has been described in our article on How do I connect to my study's SQL database?
Verify you can find your data release and working database in the list of databases on the left.
Right click on your read-only database (e.g. AdventureWorks2019), navigate to the Tasks submenu and select Export Data.
You will be prompted for connection details for the source database - these are the same as you used to open SQL Management Studio earlier. Once populated, click Next.
Repeat this for the destination connection, selecting the target “_Working” database from the Database dropdown. You can then click Next.
Leave the default “Copy data from one or more tables or views” selected and click Next.
The next step asks which tables you want to copy. You can select just a few, or use the heading checkbox to select all. You can then click Next.
This step is just asking whether to run immediately - leave selected and click Next, then click Finish and wait for the copy to finish.
The last step will take some time as the schema and individual rows are copied.
...
For queries or comments regarding HIC How To Articles contact, HICSupport@dundee.ac.uk
\uD83D\uDCCB Related articles
...