Post reply

Alias name to Database

  • February 10, 2009 at 11:51 pm

    #155265

    Hi all,

    I have a Database with the name of 'Master'.

    Can i access the same database with different name from my front-end application?

    My Scenario is,

    My application1 is pointing (in connection string) DatabaseA (using Table1 and Table2).

    Another application application2 is pointing DatabaseB (using Table3 and Table4).

    ...

    Now I moved all the tables (Table1, Table2, Table3 and Table4) to new Database 'Master'. I Don't want to change my connection string in application1, applicable2 .... I want to continue the same connection string. Now i want to give the alias name to my new database 'Master' as DatabaseA and DatabaseB. So my application will start using the 'Master'.

    Can u please suggest me?

    Advance Thanks.

    Ramesh.p

  • February 11, 2009 at 12:05 am

    #941863

    Hi,

    you can use databsae synonyms for this.

    check the below example.

    The following T-SQL creates the synonym:

    CREATE SYNONYM [dbo].[DimProduct]

    FOR

    [AdventureWorksDW].[dbo].[DimProduct]

    If you now execute "SELECT * FROM DimProduct" in the AdventureWorks database, SQL Server returns data from the AdventureWorksDW.dboDimProduct table.

    For more details refer books online.

    Regards,

    Sriram

    Sriram

  • February 11, 2009 at 12:14 am

    #941865

    Hi Sri,

    Confusion is you are giving alias name to table or database?

    I need database.

    by

    Ramesh.P

  • February 11, 2009 at 12:38 am

    #941872

    Good Day,

    Using the name master for a database name is not the best idea, as this is the same as the system databases.

    If you created the tables inside the MASTER database (not a good idea) but you can do it.

    I know tables can have aliases, but i am not sure about databases.

  • February 11, 2009 at 12:56 am

    #941876

    As far as I know, there is no way to provide a database an alias name.

    By the way why would you want to do this?

    Just for the reason that your lazy to change the name in your connection string is a little too much to ask...dont you think!:hehe:

  • February 11, 2009 at 1:24 am

    #941883

    rameshnkl (2/10/2009)

    I have a Database with the name of 'Master'.

    :w00t: Shall we understand you manage to create a "master" database in your SQL Server environment or happens that you have created user tables inside your "master" database?

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • February 11, 2009 at 1:36 am

    #941890

    Sorry. Actually i mean, 'Master' is a example database name.

    No probs. Take my database name is 'Something'.

  • February 11, 2009 at 1:39 am

    #941892

    Problem is front-end not in my control. So i can't change the connection string.

    ok?

  • February 11, 2009 at 2:33 am

    #941921

    I also want to know the solution so I m including myself

    Thanks

  • February 11, 2009 at 2:41 am

    #941927

    Hello,

    Not sure if this works for you.

    My firm understanding We don't have an option to create a alias name for the database, you can create the alias for tables.

    But you can create a database snapshot and access the Database with the old same name.

    NOTE: Snapshot is only ment for reporting( i mean you can read the data and you cannot update)

    Let me know if this works for you.

    Syntax for creating snapshot

    Create database ON

    (Name='' FileName='')

    AS SNAPSHOT OF

    P.S: if you have too many updates to master database then snapshot growth will spike up.

  • February 11, 2009 at 2:44 am

    #941930

    Thank for reply.

    No. i want to do all operation(Insert, Update, Delete and Select)

  • February 11, 2009 at 2:45 am

    #941931

    rameshnkl (2/11/2009)

    Sorry. Actually i mean, 'Master' is a example database name.

    No probs. Take my database name is 'Something'.

    Got it. You may want to check this http://www.mssqltips.com/tip.asp?tip=1620

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • February 11, 2009 at 2:51 am

    #941934

    Thank Old hand.

    The link provided by you expalining alias to Server in SQL Server configuration.

    But my requirement is Alias to database name;

    by

    ramesh

  • February 11, 2009 at 3:51 am

    #941968

    I waiting for the answer still.

    Could pls anyone assist this issue?

    -Ramesh.P

  • February 11, 2009 at 3:57 am

    #941971

    ok.

    Setting the alias name to Database is possible or not?

    - Ramesh.P

Viewing 15 posts - 1 through 15 (of 19 total)

You must be logged in to reply to this topic. Login to reply