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
Post a Comment