Post reply

How to export SQL scripts to the SQL Server?

  • October 20, 2014 at 5:13 am

    #291178

    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

    #1753554

    SSMS: Your_database/Right-mouse-click/Tasks/Generate scripts/Script entire database and all database objects

  • October 20, 2014 at 1:41 pm

    #1753613

    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.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • October 21, 2014 at 12:54 am

    #1753669

    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