How to restore a DB with DATA and Schema generated through script ?
-
i created a db through script and now i want to restore in a new DB on a new server. i need method.
-
i created a db through script and now i want to restore in a new DB on a new server. i need method.
Would that be MySQL, or another database-server? If it is a MySQL-script with create and insert-statements, you'll only need to execute it. If it is a SQL Server backup, you'd need to use the restore command.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)
-
Would that be MySQL, or another database-server? If it is a MySQL-script with create and insert-statements, you'll only need to execute it. If it is a SQL Server backup, you'd need to use the restore command.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)
yes it is in Sql Server 2008r2. kindly share the restore commands with complete procedure.
-
yes it is in Sql Server 2008r2. kindly share the restore commands with complete procedure.