October 20, 2014 at 5:13 am
Hi
Recently i have recovered the SQL database from corrupt one with help of SQL recovery tool but i want to save the database as SQL compatible script on local system not Server at that time. But now i want to export the database to the SQL Server. I am using SQL Server 2008 R2. By attaching batch file and access the database on the Server. If yes then guide me how to do such task.
Please help!!!!!
SSMS Expert
October 20, 2014 at 10:00 am
SSMS: Your_database/Right-mouse-click/Tasks/Generate scripts/Script entire database and all database objects
October 20, 2014 at 1:41 pm
What do you mean by SQL compatible? SQL Server can't generate 100% SQL code. And no RDBMS can use it, either. SQL Server will generate T-SQL code which is the dialect used by SQL Server.
October 21, 2014 at 12:54 am
SQL Compatible script option is inside the tool which comes after recovery of corrupt SQL database hence to save on local machine. But now I need to export to the SQL Server. I asking about the way how can i access on SQL Server.
Please if you don't know the answer leave it don't give foolish suggestions which are not workable
SSMS Expert
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply