How to Run .sql File Script In SQL Server?

Nimisha Ramesh | Modified: 2016-03-02T10:55:24+00:00 | Data Recovery, How To|

How to Run .sql File Script In SQL Server?

SQL Recovery software executes SQL database recovery process effectively from SQL server 2012, 2008 / 2008 R2, 2005, 2000 versions and to meet the user need to export and save recovered MDF/NDF file data accordingly two export database options are provided: SQL Server Database and SQL Server Compatible SQL Scripts.

SQL Compatible SQL Scripts

 

How to Run .sql File Script in SQL Server? – Know it Here!

Once SQL server compatible SQL scripts are created and saved in any of the system location, user can export the database to the server when it is needed. Follow the steps given below to get the SQL Recovery software via created SQL Compactable scripts uploaded and ready to run in the server.

To export database first carry the exported script files in the machine where you have to run the script, then follow the steps:

Step 1 — >> Open command prompt

Start -> run -> cmd>>OK

Command Prompt

Step 2— >>Run command cd\ on command prompt

Step 3 — >> Copy DATABASENAME.bat file folder path

Step 4 — >>Type following command on command prompt and hit enter

cd “Folder path location”

Step 5 — >> If you type databasename.bat file only you will get the help info like this:

C:\Users\Steve\Desktop\SysTools_SQLRecovery_Travel_10_29_2012_12_25_19>travel.bat

Syntax: <batch file path> [<user name> <password>] <server name> <database name>

Options:

  • batch file path    : path of batch file which will run the exported SQL scripts
  • user name password : user name and password for SQL Server(for SQL Server Authentication)
  • server name        : instance of SQL Server to which to connect
  • database name      : name of database to which data will be exported

Step 6 — >>Create new databases into SQL server

Step 7 — >> Type following command on command prompt

<batch file path> [<user name> <password>] <server name> <database name>

[ ..optional field…] username and password are optional

<batch file path> <server name> <database name> ——-> sufficenthit enter ex.

travel.bat pcvita137\SQL2000 export_demo…..hit enter

This way user can export the .sql File Script In SQL Server.

SQL Recovery Software- Ultimate Solution for User Friendly SQL Database Recovery!

There can be multiple reasons that resist user from accessing MDF file database but with the help of SQL Recovery software now it is possible to repair and recover MDF/NDF (primary and secondary database) files. Once recovery process is done user can export healthy SQL database to SQL Server Database and SQL Server Compatible SQL Scripts. To run sql file script In SQL server user can follow the steps given. Tool successfully works with SQL Server 2012, 2008 / 2008 R2, 2005, 2000 Database files.

Leave a Reply

Exclusive Offers & Deals, Grab it Now!

Systool Offer
Live Chat