question

awani avatar image
awani asked

Importing data on a file server into sql database

Is it possible to import data from a file server into sql? please permit my ignorance I have only imported txt file into sql using SSMS on the host machine. Thanks in advance
data-import
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

jason_clark03 avatar image
jason_clark03 answered
Hiii I analyze your issue and found an article about it. This article contains all useful information about how to import data on a file server into SQL database. Please follow the link: [ https://www.mssqltips.com/sqlservertip/1207/different-options-for-importing-data-into-sql-server/][1] And make sure you have a backup of your SQL database. The mentions step is not easy to use with important data but it is the only method to import data. So please careful and I have mention another link of a third party tool which is capable to [recover SQL database][2] in case your data were corrupted. I hope this information useful for you. Thank You [1]: https://www.mssqltips.com/sqlservertip/1207/different-options-for-importing-data-into-sql-server/ [2]: https://www.systoolsgroup.com/sql-recovery.html
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

dleyden avatar image
dleyden answered
Depending on your environment you will most likely run in to kerberos issues and the service running the SQL engine will not be authenticated to access those network files (because admins will have no way of knowing who was actually behind the request). If the IT department is friendly they will set up kerberos double hop for you enabling the service to pass on your credentials for the request. Otherwise you can install SQL command-line utilities on your laptop and use that to upload the files from the network.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.