Posts

Showing posts from November, 2023

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