Database Administrators Asked on November 11, 2021
I’m a PostgreSQL DBA learning SQL Server 2019.
The setup :
The problem :
The solution I know :
Is there a way to export a database to another database, on demand ? Or is the dump/transfer/restore the way to go ? (that’s what I would do with PostgreSQL)
I don’t know all the SQL Server keywords and terminology and my google-fu was unsuccessful. Most solutions I find are obviously about how to set up replication over a reliable/permanent network. which doesn’t fit my requirements.
Well... it turn out it couldn't be easier.
Right click on database -> Tasks -> Copy database...
Answered by ker2x on November 11, 2021
Get help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP