Learn dotnet
Wednesday, 2 May 2018
Run Large(eg: 10gb) script file in MS SQL database
Import/Run large(eg: 10gb) script file in MS SQL database using below command:
1. Open command prompt with Administrator mode
2.
sqlcmd -S ServerName -U UserID -P Password -d DataBaseName -i C:\Users\gprao\Downloads\ProjectTrac\ProjectTrac.sql
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
git rebase command - baseed on master branch to our branch
Difference between IEnumerable and IEnumerator
Difference between IEnumerable and IEnumerator IEnumerable: 1. Make the syntax sorter. 2. IEnumerable uses IEnumerator internally 3. I...
Message brokers - MSMQ - RabbitMQ - Azure Service Bus
Message brokers: Below are the message service brokers. those are used to store messages and consume the messages and each broker has so...
Sql query using Entity framework in MVC / C#
Sql query using entity framework. In the below example we can use sql query or stored procedure or view. public List<Appointmen...
No comments:
Post a Comment