銷售: 1-800-867-1380

 none
Reg Data-tier Applications node in sql management studio R2

    問題

  • Hi

    I had installed SQL management studio R2 express. I do not get  Data-tier Applications node in sql management studio r2. What do we need to install to get this node. Please suggest.

    Thanks & Regards,

    Usha.

    2012年2月16日 下午 05:13

解答

所有回覆

  • Hi,

    I guess your need install Visual Studio for create SQL Server Data-tier Application, try it as following steps:

    File-New-Projects-DataBase (In the left tree)-SQL Server, then your will find "SQL Server Data-tier Application" on the list.

    Have a try, hope it helps.


    Please mark the replies as answers if they help or unmark if not. If you have any feedback about my replies, please contact msdnmg@microsoft.com Microsoft One Code Framework

    2012年2月17日 上午 07:39
    版主
  • Hi

    I had tried the above steps but still the "Data-tiet application" tab does not come in my SQL management studio. Does it comes in SQL Azure or in local sql management studio.

    Please suggest.

    Thanks & Regards,

    Usha.

    2012年2月17日 上午 08:02
  • Hi,

    I mean you need to use VS to create "SQL Server Data-tier application", not use SQL Management sudio.

    Hope it helps.


    Please mark the replies as answers if they help or unmark if not. If you have any feedback about my replies, please contact msdnmg@microsoft.com Microsoft One Code Framework

    2012年2月17日 上午 08:04
    版主
  • Hi

    Thanks for your reply. I tried the steps in VS but the "SQL Server Data-tiet application" tab does not show up in my SQL Manegment studio.

    My assumption is that if we install SQL Server Management studio R2, the data-tier application" tab should show up. So what is the problem and how to fix this problem. Please suggest.

    Regards,

    Usha.

    2012年2月17日 上午 08:36
  • Hi,

    Find that application in visual studio dialog box, look at following screenshot:

    Hope it can help you.


    Please mark the replies as answers if they help or unmark if not. If you have any feedback about my replies, please contact msdnmg@microsoft.com Microsoft One Code Framework

    2012年2月17日 上午 08:54
    版主
  • Hi

    I checked the below link "Microsoft® SQL Server® 2008 R2 Data-Tier Application Framework v1.1 Feature Pack"

    http://www.microsoft.com/download/en/details.aspx?id=24000

    I had installed 1033\amd64\DACFramework.msi still the data tire-applications tab does not show up in SQL Server management studio.

    In my view the SQL Server management studio R2 shows a last tab "data-tier applications" below manage but it is not appearing. It shows SQL management studio as below.

    Please suggest.

    Thanks & Regards,

    Usha.

    2012年2月17日 上午 09:11
  • Hi Usha,

    Refer to http://msdn.microsoft.com/en-us/library/ee210455.aspx.

    From this article. You can create date-tier application (DAC) by two ways, one is by VS (as i was metioned above), the another way is use powsershell command or Extract Data-tier application wizard in SQL Server Management Studio, it seems you need create a database choose Tasts-Extract Data-tier application:

    http://msdn.microsoft.com/en-us/library/ee210526.aspx

    Hope it can help you.


    Please mark the replies as answers if they help or unmark if not. If you have any feedback about my replies, please contact msdnmg@microsoft.com Microsoft One Code Framework

    • 已標示為解答 Usha 2012 2012年2月17日 上午 10:12
    2012年2月17日 上午 09:44
    版主
  • Hi Arwind,

    Thanks for your reply.

    Regards,

    Usha.

     

    2012年2月17日 上午 10:21