SQLCMD -S LOCALHOST -d AdventureWorks -i C:\script.sql -E
You will be able to see the below snippet once the schema and data is successfully loaded to the destination database.
Wednesday, 3 April 2013
How to Execute Large Database script in SQL Server?
In case the generated scripts files are too large to open in SQL Server Management Studio, you can utilize the SQLCMD Utility to execute the scripts.
You will be able to see the below snippet once the schema and data is successfully loaded to the destination database.
You will be able to see the below snippet once the schema and data is successfully loaded to the destination database.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment