如何使用命令提示符运行更大的脚本文件 [英] How to run larger size script file using command prompt

问题描述

我有更大尺寸的sql脚本文件我想用命令提示符执行



脚本文件大小有613354 KB





i尝试显示错误





C：\windows \ system32> sqlcmd -d spyder -ic：/users/documets/script.sql

sql cmd错误microsoft odbc驱动无法打开数据库spyder





如何修复此错误



我尝试了什么：



i有更大尺寸的sql脚本文件我想用命令提示符执行



脚本文件大小为613354 KB





i尝试显示错误





C：\ windows \ system32> sqlcmd -d spyder -ic：/users/documets/script.sql
$ b用于sql server登录失败的$ b sqlcmd错误microsoft ODBC驱动程序13

sql cmd错误microsoft odbc驱动无法打开数据库spyder





如何修复此错误

i have larger size sql script file i want to execute using command prompt

The script file size has 613354 KB


i tried shows error


C:\windows\system32>sqlcmd -d spyder -i"c:/users/documets/script.sql"
sqlcmd error microsoft ODBC Driver 13 for sql server login failed for user
sql cmd error microsoft odbc driver cannot open database spyder


how to fix this error

What I have tried:

i have larger size sql script file i want to execute using command prompt

The script file size has 613354 KB


i tried shows error


C:\windows\system32>sqlcmd -d spyder -i"c:/users/documets/script.sql"
sqlcmd error microsoft ODBC Driver 13 for sql server login failed for user
sql cmd error microsoft odbc driver cannot open database spyder


how to fix this error

推荐答案

再次阅读错误消息。它与文件的大小无关。



它告诉你指定的凭据，或者在你未指定的情况下，无法登录数据库spyder。



您可能需要告诉sqlcmd用于登录数据库的凭据：

Read the error message again. It has nothing to do with the size of the file.

It's telling you the credentials specified, or in your case NOT specified, did not work to login to the database "spyder".

You're probably going to have to tell sqlcmd the credentials to use to login to the database:

sqlcmd -d spyder -U username -P password -i "C:\users\username\documents\script.sql"

这篇关于如何使用命令提示符运行更大的脚本文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！