SQL Server Hosting Toolkit

Discussion in 'Databases' started by millsyadam, Mar 19, 2007.

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

    We have tested this tool when it first released and it worked fine on our database.


    We didn't like this too much because of


    1) The tool works great w/ small database. The script file can become massive if you have large DB (many rows)


    2) Its rather complicated to use.


    I much preferred using our SQL Attach tool in the control panel.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
  2. Hi Bruce
    Thanks for the response
    Do you have some instructions/screen shots for your sql attach tool.
    Does it allow the database (schema and data) to be uploaded/updated seach time by attaching the sql script?
    Thanks
    Adam
     
  3. Bruce

    Bruce DiscountASP.NET Staff

  4. Hi Bruce

    Thanks for that sounds fairly straightforward, just a few more questions.

    1. By attaching the mdf file I am attaching everything I created on my local machine(database, schema, stored procedures etc) ?
    2. I will be purchasing an account with a sql server database, however after looking on my sql express explorer I can see that I have two databases, one is the aspnet.mdf database created with all my user info, the other is my database with product info. How do I attach two databases?
    3. If My live database is being updated on the internet, ie users being added, products added via admin, but I make a change to my local database, for example adding a stored procedure how do I add the database change, without overwriting all the data?
     
  5. 1>Yes,attaching the MDF creates the schema,Stored Procedures and data on the remote server.

    2>After you purchase the MS SQL 2005,you can attach the product info database file(mdf) using the web based Attach tool in the SQL Tool Suite(Control Panel) and use the folling command line utlity to create the ASPNET.MDF database schema on the remote server.(Attach the product info MDF first,else the ASP.NET schema will be overwritten)

    aspnet_regsql.exe -S [DB Server Name] -U [DB login] -P [Password] -A all -d [Database name]

    3>If you make any change to the local DB,you can export the data using the Export option(Only available in SQL Server Management Studio) .But in case on a stored procedure,you will have to manually add the SP over to the remote DB.

    Once again,you can alwasy export the data from local to remote DB via 'SQL Server Management Studio' and not SQL Express version.

    Vikram

    DiscountASP.NET
    www.DiscountASP.NET
     
  6. Thanks Vikram

    on 2> How Do I run a command line utility?

    3> To manually add the SP over to the remote DB would I need to run sql to do this, if so how is this done.

    Cheers
    Adam
     
  7. See : http://kb.discountasp.net/article.aspx?id=10413
    1. Open the command prompt on your local computer, and navigate to: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727
    2. Execute the command: aspnet_regsql.exe -S [DB Server Name] -U [DB login] -P [Password] -A all -d [Database name]

    To add the SP to the remote DB,you use a client side MS SQL tool such as 'SQL Server Management Studio' and create a SP manually.I believe you should be able to do this using Visual Studio too....using Server Explorer (View>Server Explorer>Create a new connection to your remote DB).Once you connect to your DB >Right Click on Stored Procedures>Add New Stored Procedure)

    Vikram

    DiscountASP.NET
    www.DiscountASP.NET
     
  8. Thanks again for your excellent support.

    I am looking at my control panel and I see when go on the 'Add SQL 2005 Database' tab I am given a prompt of
    Database Name: SQL2005_290796_

    Into this I need to put in my products database, I then run the command line to add my aspnet.mdf database and both my databases will be added under the same MS SQL Server 2005 account for $10 a month?
     
  9. It seems you don?t have the MS SQL add-on yet.
    First select any suitable name for your DB in the textbox you see .So something like SQL2005_290796_anything_here

    Once you are done with this,DASP will provision your database, which usually takes less than 24 hours. Once provisioned , you will see more options(Database Info, Login Manager, SQL Tools) in here (Control Panel>Database Management>MS SQL 2005).In the SQL Tools, you will have the attach (using the Attach tool : see http://kb.discountasp.net/article.aspx?id=10431) your products database as mentioned in my earlier posts.
    Then run the command line to create the aspnet.mdf database.

    Yes both these database can co-exist under the same MS SQL Server 2005 account for $10 a month.

    Vikram

    DiscountASP.NET
    www.DiscountASP.NET
     
  10. Okay Vikram I will do that,
    My SQL2005_290796_anything_here name doesnt need to match my products database name then?
     
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