Attach live data to UAT server

(0) Share

Report

Posted on by manish.yadav

1,835

Dear Experts, I have one live server and one test server(UAT). In my UAT server there have very old data. I want to attach the live database backup there. How can I take a backup of live data and attach with UAT server. please give me some idea to do this.

*This post is locked for comments

All responses (4)

Answers (0)

Suggested answer

Zaid Tariq 2,266 on at

Like (0)

Report

RE: Attach live data to UAT server

Hi,
Attach you management Studio with the live data server and take a back.
Now disconnect and Reconnect SQL Management Studio with the UAT server.
Restore the backup at UAT Server.
Thanks
Suggested answer

Amol Salvi 18,694 on at

Like (0)

Report

RE: Attach live data to UAT server

Take SQL backup from Live DB and restore it on UAT server.
Suggested answer

CDsilva 4,184 on at

Like (0)

Report

RE: Attach live data to UAT server

Hi MKY,

You can take SQL backup of the Live and UAT database, Restore the UAT database with the Live backup.

you can refer the below blog for the steps how to take SQL backup.

docs.microsoft.com/.../create-a-full-database-backup-sql-server

www.archerpoint.com/.../how-backup-and-restore-nav-database-sql-server-management-studio
Suggested answer

RobertasR 5,002 on at

Like (0)

Report

RE: Attach live data to UAT server

Hi,

if tables structures in Live and UAT databases are the same, you can try using 'Export to a Data File' and 'Import from a Data File' functions from within NAV. It's very simple and self-explanatory once you run these, but just need to make sure tables are the same, otherwise you can't import it into UAT.

Hope that helps.

Robertas