What specific conditions database should meet, before you can bulk copy data into it using bcp?
- 1 Answers
- 1096 Views
- I also Faced
- E-Mail Answers
Answer Posted / Deepshikha Chauhan
The following conditions must be met to bulk copy data into a SQL Server database using bcp:
1. The source and destination databases must be compatible in terms of data types.
2. The target table should have the same structure as the source file, including column order and data types.
3. The user running bcp must have the necessary permissions to access the source file and the destination database.
4. The SQL Server instance should support bulk copy operations (bcp). This is usually enabled by default.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can sql servers link to other servers like oracle?
Explain “row_number()” in sql server with an example?
What is a scheduled job or what is a scheduled task?
Can one drop a column from a table?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
How can I check that whether automatic statistic update is enabled or not?
How to convert character strings into numeric values?
Why use identity in sql server?
Can we shrink data file in sql server?
Why and when do stored procedure recompile?
What is self contained sub query?
How to rebuild the master database?
What are the different types of subquery?
When should you use an instead of trigger?
What is the difference between upgrade and migration in sql server?
