I backed up an old SQL Server DB with .CSV files for each table. The old DB is now gone; the .CSV files are all I have.
Now I want to create new DB and upload all those csv file (my old db removed) .
I looking for a way to upload multiple csv files via the sqlServer gui and without any constrain .
I want to disable the constrain because if not the sql will tell that I a problem with the FK
I thought to running this command
EXEC sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all" but I think it not help me because I need to running it before I upload all the csv files , and before I upload them I not have any table in my new DB
thank you all.