Monday, March 19, 2012

DMO & SQL 2005

Will SQL 2005 still have SQLDMO?
Will the objects have the same name as with SQL7/SQL2000?
dirk.I believe it will be supported for backward compatibility but the new
technology is known as SMO.
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Dirk" <dirk@.nospam_to_remove_ofcourse.woodstone.nu> wrote in message
news:elhsDVSZEHA.3664@.TK2MSFTNGP12.phx.gbl...
Will SQL 2005 still have SQLDMO?
Will the objects have the same name as with SQL7/SQL2000?
dirk.|||Yes, there will be SQLDMO 9 shipping in SQL Server 2005. It will work at
the 8.0 level against a SQL Server 2005 system, so no new features will be
exposed, but it will continue to function.
Richard Waymire, MCSE, MCDBA
This posting is provided AS IS with no warranties, and confers no rights.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23Z1PiZSZEHA.3112@.TK2MSFTNGP09.phx.gbl...
>I believe it will be supported for backward compatibility but the new
> technology is known as SMO.
> --
> Tom
> ---
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "Dirk" <dirk@.nospam_to_remove_ofcourse.woodstone.nu> wrote in message
> news:elhsDVSZEHA.3664@.TK2MSFTNGP12.phx.gbl...
> Will SQL 2005 still have SQLDMO?
> Will the objects have the same name as with SQL7/SQL2000?
>
> dirk.
>|||So it will use the same objects/syntax as those for SQL2000 then?
dirk;
"Richard Waymire [MSFT]" <rwaymi@.online.microsoft.com> wrote in message
news:uV1sFoSZEHA.3144@.TK2MSFTNGP12.phx.gbl...
> Yes, there will be SQLDMO 9 shipping in SQL Server 2005. It will work at
> the 8.0 level against a SQL Server 2005 system, so no new features will be
> exposed, but it will continue to function.
> --
> Richard Waymire, MCSE, MCDBA
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:%23Z1PiZSZEHA.3112@.TK2MSFTNGP09.phx.gbl...
>|||Yes.
Richard Waymire, MCSE, MCDBA
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dirk" <dirk@.nospam_to_remove_ofcourse.woodstone.nu> wrote in message
news:eWbpZpTZEHA.2444@.tk2msftngp13.phx.gbl...
> So it will use the same objects/syntax as those for SQL2000 then?
>
> dirk;
> "Richard Waymire [MSFT]" <rwaymi@.online.microsoft.com> wrote in messag
e
> news:uV1sFoSZEHA.3144@.TK2MSFTNGP12.phx.gbl...
> rights.
>
>|||Great thanks.
"Richard Waymire [MSFT]" <rwaymi@.online.microsoft.com> wrote in message
news:eNDWDJUZEHA.1048@.tk2msftngp13.phx.gbl...
> Yes.
> --
> Richard Waymire, MCSE, MCDBA
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Dirk" <dirk@.nospam_to_remove_ofcourse.woodstone.nu> wrote in message
> news:eWbpZpTZEHA.2444@.tk2msftngp13.phx.gbl...
at[vbcol=seagreen]
>

No comments:

Post a Comment