i'm using VB.NET AND SQL SERVER AND HAD PROBLEM TO RESTORE PREVIOUSLY BACKUP TEXT FILE.

What is the problem exactly?

If the text file contains queries each on a line of their own then you could loop through the file line by line and execute the query that is on each line.

exactly, i have to restore sql server data, which was backup previously in text file using VB, VB.NET programming techniques.

Could you provide an extract from the text file to show how the SQL is stored?

Is every query on a new line?

i have backup database file in text file format, which includes all tables, views etc which are included on one database. I have to restore those text file data into running same database on SQL Server using VB.NET.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.