Search code examples
sql-serverdatabasebcp

Does BCP create the destination object?

I apologize if I have a fundamental misunderstanding but basically I wanted to know if there is a way to go directly from ONLY .bcp files to creating a SQL Server database. I have not dealt with .bcp files before and have no format files or know anything about the schema of the database we are trying to re-create. Is there some sort of utility wihtin SQL server management studio that can do what I am asking or do I just not have enough resources to create a database out of this data. Any help is appreciated.

Solution

  • BCP only builk insert the data. So you need to have a blank database first to insert to with the bcp files.

    You can use the bcp command line to run with those bcp files. But you need to know the order of the files to run if the db has FKs.