HELP !!! - How can a run a sql script to install a

Discussion in 'Databases' started by aplaz, Feb 19, 2004.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. aplaz

    aplaz

    I am new in the .NET developing world. My problem is that I am trying to install a DB that comes with the starter kit for Commerce, and I need to rum some sql scripts that come with it, and I do not know how to do it...how can I run these scripts?

    I am using a Web Matrix and MS SQL Server over Windows XP Pro.

    Thanks,

    aplaz
     
    aplaz, Feb 19, 2004
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    If you do not have SQL Query analyser, you can also use the command line interface, osql.exe, which comes with MSDE.

    Syntax:

    osql -S [servername] -U [sqluser] -P [password] -i [File_containing_SQL_Script]

    eg. osql -S mssql01.discountasp.net -U testuser -P password -i installscript.sql


    quote:Originally posted by aplaz

    I am new in the .NET developing world. My problem is that I am trying to install a DB that comes with the starter kit for Commerce, and I need to rum some sql scripts that come with it, and I do not know how to do it...how can I run these scripts?

    I am using a Web Matrix and MS SQL Server over Windows XP Pro.

    Thanks,

    aplaz
    </blockquote id="quote"></font id="quote">
     
    Bruce, Feb 20, 2004
    #2
  3. tourneymanagerpro

    tourneymanagerpro

    If you have the MS SQL Server client tools installed:
    <ul>[*]Open MS SQL Server Query Analyzer (from Start->Programs-MS SQL Server menu, or through Enterprise Manager) [*]Connect to database you want to run the script on [*]Click File->Open... and select the script you want to run [*]Press F5 key or click the Arrow toolbar button to execute the script[/list]
     
    tourneymanagerpro, Feb 20, 2004
    #3
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page