Get Database tables and there structure and database tables data. Backup database tables and data without bak file. database version issue backup. database backup version error

 This will create your table script

Get Database tables and there structure and database tables data.  Backup database tables and data without bak file. database version issue backup. database backup version error

select database

select tables 

then go to view

above

object explorer details

select all tables except folders 

then right click the mouse > script table as > create to > new query editor window

you will get all tables

then save it to extention name.sql or whatever you want it to save in notepad or other.


This will create your tables data backup 

Right Click on database which you wanted to get data

Tasks > Generate Scripts > Next > if you want specific tables so select other wise next

select Advance Button > Types of data to Script Line and Select > it was schema only 

you select it > Data Only > then select file path will be save in fileName select path

Next >  Next > it will generate all tables data and preparing all success tables status 

with green >  see if all green and save it then next of finish and go to your path it 

will be there and you can get the data.

Comments

Popular posts from this blog

Access to XMLHttpRequest at 'https://localhost:44363/api/Values' from origin 'http://localhost:4200' has been blocked by CORS policy: No 'Access-Control-Allow-Origin' header is present on the requested resource.