SQL Server DBA Tutorial 108 - Import a .sql data file into SQL Server with SQLCMD

*********************************************************************************************
Import a .sql data file into SQL Server with SQLCMD
***********************************************************************************************
If your .sql file is a large in size 50MB+, then I recommend you use SQLCMD.
the command line utility that comes bundled with SQL Server.
It is easy to use and it handles large files as well. I tried it with the size of 21GB file using the following command:

Note : you can run this command in cmd and PowerShell.

Syntax Summary :
-S: ServerName or localhost
-d: Database Name(we are targeting)
-U: Login Username
-P: Login Password
-i: inputfile
-o: outputfile
-?: show syntax summary

Note : Flow the Process shown in video.
😉Subscribe and like for more videos:
💛Don't forget to, 💘Follow, 💝Like, 💖Share 💙&, Comment

Tutorial Link:

Thanks & Regards,
Chitt Ranjan Mahto "Chirag"
_____________________________________________________________________
Note: All scripts used in this demo will be available in our website.
Link will be available in description.
#sqlserver
#sqlservermanagementstudio
#sql_server
#sqlservertutorial
#chiragstutorial
#databasetutorial
#sqlqueries
#sqldba
#database
#databasemanagement
#chiragstutorial
#chirags
#createdatabaseinmysql
#DBATutorial
#DBATutorialLearning
#DBAEducation
#DBATutorialFree
#DatabaseTutorial
#SQLServerDatabaseTutorial
#SQLServerDBATutorial
#MicrosoftSQLServerDatabaseTutorial
#ChiragsDBATutorial
#ChiragsDatabaseTutorial
#ChiragsSQLServerDatabaseTutorial
#ChiragsSQLServerDBATutorial
#ChiragsMicrosoftSQLServerDatabaseTutorial
#CreateDatabaseinSQLServer
#CreateDatabasewithT-SQL