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...
> >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.
--
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 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...
>> >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.
>> >
>> >
>>
>
>|||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...
> > 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...
> >> >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.
> >> >
> >> >
> >>
> >>
> >
> >
> >
>

No comments:

Post a Comment