BeatsByDr.Dre 8 Report post Posted November 22, 2016 Is there a way to transfer datas of a database to a new database? Quote Share this post Link to post Share on other sites
Eviles 179 Report post Posted November 23, 2016 Hello. You can do a back up and use it to do a restore from a certain database. It will work on SQL 2005+ * Back Up On SQL Server Management Studio, right click on database to do process and navigate to Tasks, sub-option Back Up. 1. Database selected to do a backup 2. Backup name 3. Destination, to save backup * Restore On SQL Server Management Studio, right click on database to do process and navigate to Tasks, sub-option Restore, sub-option database. 1. Database selected to restore 2. Restore a database from a avaiable database arealdy attached on instance 3. Restore a database from a back up (SELECT IT) and navigate to back up destination, then click ok. PS: It will copy existing data from a attached database in your intance as a back up and can be used to copy data to a new attached database in instance. 1 Quote Share this post Link to post Share on other sites
BeatsByDr.Dre 8 Report post Posted November 23, 2016 2 hours ago, Satan said: Hello. You can do a back up and use it to do a restore from a certain database. It will work on SQL 2005+ * Back Up On SQL Server Management Studio, right click on database to do process and navigate to Tasks, sub-option Back Up. 1. Database selected to do a backup 2. Backup name 3. Destination, to save backup * Restore On SQL Server Management Studio, right click on database to do process and navigate to Tasks, sub-option Restore, sub-option database. 1. Database selected to restore 2. Restore a database from a avaiable database arealdy attached on instance 3. Restore a database from a back up (SELECT IT) and navigate to back up destination, then click ok. PS: It will copy existing data from a attached database in your intance as a back up and can be used to copy data to a new attached database in instance. Thank you! will try this out! does it work if i use 2008 and restore it on 2012 or 2014 databases? Quote Share this post Link to post Share on other sites
Eviles 179 Report post Posted November 23, 2016 Yes. But if you use a old database and apply in a new one with others tables, example a v.1x to a v.2x, maybe it will give a error when login. You should try this out .. Also you can call me using @MyName, don't quote too long posts, respect our admin xD. 1 Quote Share this post Link to post Share on other sites
BeatsByDr.Dre 8 Report post Posted November 23, 2016 @Satan hahaha alright Thank you! i will tag you again if i have questions Quote Share this post Link to post Share on other sites