i'm using VB.NET AND SQL SERVER AND HAD PROBLEM TO RESTORE PREVIOUSLY BACKUP TEXT FILE.
dwel 0 Newbie Poster
etftw 0 Light Poster
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.
dwel 0 Newbie Poster
exactly, i have to restore sql server data, which was backup previously in text file using VB, VB.NET programming techniques.
etftw 0 Light Poster
Could you provide an extract from the text file to show how the SQL is stored?
Is every query on a new line?
dwel 0 Newbie Poster
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.