Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • sharad kumar rathore 23 posts 42 karma points
    Jul 05, 2013 @ 15:27
    sharad kumar rathore
    0

    Create new database

    How to create new database table in umbraco ?

  • Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib
    Jul 05, 2013 @ 15:31
    Jan Skovgaard
    0

    Hi Sharad

    You can add a custom table to the Umbraco database on your database server for instance. But what are you trying to achieve? Whould the purpose of your table-creation be? Perhaps it's better to connect to an alternate database to keeps things seperate? It of course depends on what it is you're trying to achieve I guess.

    /Jan

  • sharad kumar rathore 23 posts 42 karma points
    Jul 05, 2013 @ 15:50
    sharad kumar rathore
    0

    Hi Jan,

    I am using Umbarco, I am just a begginer and I want to create custom database in my website but i am unable to access my database. can you please give any documentation or any link which is guide me to step by step. 

  • Niels Lynggaard 192 posts 550 karma points
    Jul 05, 2013 @ 16:25
    Niels Lynggaard
    0

    Ususally I use Microsoft SQL Management Studio to connect to my database and work on it when needed. You should be able to just google Microsoft SQL Management Studio and find a version that fits the version of MSSQL you're running (IF you're using MSSQL).

    You cannot work directly on the database inside Umbraco backend.

    Cheers,

    Niels

  • sharad kumar rathore 23 posts 42 karma points
    Jul 08, 2013 @ 12:12
    sharad kumar rathore
    0

    Hi Niels,

    we are using sql server managment studio R2 and MS Sql but unable to connect database.so can you please suggest any link or article that guide to link step by step and  how to comunicate with the Database in Umbraco.

     

    Regards,

    Sharad Kumar Rathore

  • Niels Lynggaard 192 posts 550 karma points
    Jul 08, 2013 @ 13:08
    Niels Lynggaard
    0

    You should be able to connect to the DB through sql server management studio.This seems to be a problem with your login/setup.

    Are you SURE you're using the correct name of your instance of the db server? I think you set this up when installing sql server. I've had this problem sometimes when I just ran quickly over the setup and forgot to make a note of it.Otherwise try the name (local)

    Are you SURE that you are using the correct credentials to connect? You chose your user and pass when you set up Umbraco. Or you could try to connect with "Windows authentication" instead of "SQL Authentication" and use your normal windows user for that.

    You should be able to find both the SQL server instance name and the login in your web.config file.

    Sorry, I don't have any resources on this, it should be straightforward if you have the right servername and credentials.

     

  • sharad kumar rathore 23 posts 42 karma points
    Jul 08, 2013 @ 13:17
    sharad kumar rathore
    0

    Hi Niels,

     

    Sorry for the confusion. Actually, I am able to login to my MSSQL Server database using Management Studio but don't know actually how to configure and use the particular database & table in Umbraco. I will appreciate if you can point me to some steps/links to configure SQL Server DB/Table in umbraco.

     

    Thank you so much for your help in advance. Waiting for your reply on this.

    Regards,
    Sharad Kumar Rathore
  • Niels Lynggaard 192 posts 550 karma points
    Jul 08, 2013 @ 13:44
    Niels Lynggaard
    0

    Ok. Still a bit confused.. Is you site running? If so, everything is fine and the site is using your database..

    During an installation the connectionstring should be automatically written to your web.config.

    Can you tell me what it is you're trying to achieve?

    Cheers

    Niels

  • sharad kumar rathore 23 posts 42 karma points
    Jul 08, 2013 @ 15:42
    sharad kumar rathore
    0

    Hi Niels,

    I already have my umbraco website running in my local server. Now I created one Database in my DB Server (MS SQL Server 2008 R2). I wonder how to connect the website with that particular Database. Looking forward for your kind reply soon.

    Thanks & Regards,

    Sharad

  • Niels Lynggaard 192 posts 550 karma points
    Jul 08, 2013 @ 15:48
    Niels Lynggaard
    0

    But what is the purpose of that new database? What do you want it to contain?

    If you just want to switch the database, just update your web.config with the credentials for that database. However, if the database is empty, this will propably go wrong or trigger the installation wich will then populate the database.

    If you want to use the new database for something completely different, and use that in umbraco, my recommendation would be to write your own usercontrols that just gets the data out of the database the way you want to present it.

    You *could* also use the package called DEWD, it should be able to connect to databases and make it easier to work with external datasources in umbraco. I don't have any experience with that, though.

    Still, I'm curious about what it is your'e trying to accomplish? Do you want to switch the database running your website or do you want a database to contain something other than umbraco and use that data on your website?

    Cheers,

    Niels

     

  • sharad kumar rathore 23 posts 42 karma points
    Jul 10, 2013 @ 10:06
    sharad kumar rathore
    0

    Hi Niels.

    I am using sql server managment studio R2 but unable to connect database in umbraco so can you please suggest any link step by step and how to configure with the  database in umbraco.

    Regards,

    sharad

Please Sign in or register to post replies

Write your reply to:

Draft