MS SQL newbie question, please help!! thanks

Discussion in 'Databases' started by Bruce, Mar 14, 2004.

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

    Bruce DiscountASP.NET Staff

    Connect to our sql server with Query analyser.

    Open your sql script in query analyser and execute it.

    Make sure that you comment out the lines (which usually exists with commercial product) that create database and users.


    quote:Originally posted by billtei

    I purchased a website script and have all the files ready, including a .sql file. They also provided me with .mdf and .ldf files, which apparently are impossible to transfer, rendering them useless. My machine is running Windows ME (non-server environment), so I could only install the client tools (EM, QA etc) from the MS SQL 2000 Developer Edition. How can I transfer this data up to discountasp.net's server?? I have all the data I need in raw format, do I still need to create a database from scratch on a server environment? Can I execute the .sql or transfer the data somehow, without having to upgrade my entire system? This is very frustrating and no one seems to have an answer... any useful help at all is appreciated, thanks!
    </blockquote id="quote"></font id="quote">
     
  2. I purchased a website script and have all the files ready, including a .sql file. They also provided me with .mdf and .ldf files, which apparently are impossible to transfer, rendering them useless. My machine is running Windows ME (non-server environment), so I could only install the client tools (EM, QA etc) from the MS SQL 2000 Developer Edition. How can I transfer this data up to discountasp.net's server?? I have all the data I need in raw format, do I still need to create a database from scratch on a server environment? Can I execute the .sql or transfer the data somehow, without having to upgrade my entire system? This is very frustrating and no one seems to have an answer... any useful help at all is appreciated, thanks!
     
  3. worked perfectly, thank you Bruce!!

    quote:Originally posted by bruce

    Connect to our sql server with Query analyser.

    Open your sql script in query analyser and execute it.

    Make sure that you comment out the lines (which usually exists with commercial product) that create database and users.


    quote:Originally posted by billtei

    I purchased a website script and have all the files ready, including a .sql file. They also provided me with .mdf and .ldf files, which apparently are impossible to transfer, rendering them useless. My machine is running Windows ME (non-server environment), so I could only install the client tools (EM, QA etc) from the MS SQL 2000 Developer Edition. How can I transfer this data up to discountasp.net's server?? I have all the data I need in raw format, do I still need to create a database from scratch on a server environment? Can I execute the .sql or transfer the data somehow, without having to upgrade my entire system? This is very frustrating and no one seems to have an answer... any useful help at all is appreciated, thanks!
    </blockquote id="quote"></font id="quote">
    </blockquote id="quote"></font id="quote">
     
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