Search:   Namespaces Discussions .NET v1.1 Feedback

EM Module - feedback wanted Messages   Related Types This message was discovered on ASPFriends.com 'aspngibuyspy' list. PPM hi guys, I have plans to write an IBS admin-module EM-like (SQL Server Enterprise Manager), using SQL-DMO and c#. I wonder if anybody out there would like to participate on this, with ideas or code writting. If we'll reach something usable we can donate to IBS community... Petroniu Reply to this message...        =?iso-8859-1?Q?Oddur_Sn=E6r_Magn=FAsson?= Check out http://www.disill.is/dbview" target="_blank">http://www.disill.is/dbview, it's open source and free. It's old school asp thougth. ----------------------------------- [Original message clipped] -----Original Message----- From: PPM [mailto:Click here to reveal e-mail address]=20 Sent: mi=F0vikudagur, =E1g=FAst 14, 2002 10:13 To: aspngibuyspy Subject: [aspngibuyspy] EM Module - feedback wanted hi guys, I have plans to write an IBS admin-module EM-like (SQL Server Enterprise Manager), using SQL-DMO and c#. I wonder if anybody out there would like to participate on this, with ideas or code writting. If we'll reach something usable we can donate to IBS community... Petroniu | [aspngibuyspy] member Click here to reveal e-mail address =3D YOUR ID | http://www.asplists.com/asplists/aspngibuyspy.asp =3D JOIN/QUIT | http://www.asplists.com/search =3D SEARCH Archives Reply to this message...        petroniu Oddur, pretty cool stuff you wrote... Anyway, I'd like to avoid ADO, that's why I'm thinking to use SQL-DMO. But IMO the interface(presentation/navigation) is pretty cool and functional and I'd like to use some parts of it. Do you heve any interest in implementing it as an IBS module? Petroniu "Oddur Snær Magnússon" <Click here to reveal e-mail address> wrote in message news:697842@aspngibuyspy... Check out http://www.disill.is/dbview" target="_blank">http://www.disill.is/dbview, it's open source and free. It's old school asp thougth. ----------------------------------- [Original message clipped] -----Original Message----- From: PPM [mailto:Click here to reveal e-mail address] Sent: miðvikudagur, ágúst 14, 2002 10:13 To: aspngibuyspy Subject: [aspngibuyspy] EM Module - feedback wanted hi guys, I have plans to write an IBS admin-module EM-like (SQL Server Enterprise Manager), using SQL-DMO and c#. I wonder if anybody out there would like to participate on this, with ideas or code writting. If we'll reach something usable we can donate to IBS community... Petroniu | [aspngibuyspy] member Click here to reveal e-mail address = YOUR ID | http://www.asplists.com/asplists/aspngibuyspy.asp = JOIN/QUIT | http://www.asplists.com/search = SEARCH Archives Reply to this message...        =?iso-8859-1?Q?Oddur_Sn=E6r_Magn=FAsson?= I've got plans rewriting it in ado.net and C#, and when that's done there should be no ploblems converting those to ISB modules. I'll keep you guys updated. ----------------------------------- [Original message clipped] -----Original Message----- From: petroniu [mailto:Click here to reveal e-mail address]=20 Sent: mi=F0vikudagur, =E1g=FAst 14, 2002 14:21 To: aspngibuyspy Subject: [aspngibuyspy] Re: EM Module - feedback wanted Oddur, pretty cool stuff you wrote... Anyway, I'd like to avoid ADO, that's why I'm thinking to use SQL-DMO. But IMO the interface(presentation/navigation) is pretty cool and functional and I'd like to use some parts of it. Do you heve any interest in implementing it as an IBS module? Petroniu "Oddur Sn=E6r Magn=FAsson" <Click here to reveal e-mail address> wrote in message news:697842@aspngibuyspy... Check out http://www.disill.is/dbview" target="_blank">http://www.disill.is/dbview, it's open source and free. It's old school asp thougth. ----------------------------------- [Original message clipped] -----Original Message----- From: PPM [mailto:Click here to reveal e-mail address] Sent: mi=F0vikudagur, =E1g=FAst 14, 2002 10:13 To: aspngibuyspy Subject: [aspngibuyspy] EM Module - feedback wanted hi guys, I have plans to write an IBS admin-module EM-like (SQL Server Enterprise Manager), using SQL-DMO and c#. I wonder if anybody out there would like to participate on this, with ideas or code writting. If we'll reach something usable we can donate to IBS community... Petroniu | [aspngibuyspy] member Click here to reveal e-mail address =3D YOUR ID | http://www.asplists.com/asplists/aspngibuyspy.asp =3D JOIN/QUIT | http://www.asplists.com/search =3D SEARCH Archives | [aspngibuyspy] member Click here to reveal e-mail address =3D YOUR ID | http://www.asplists.com/asplists/aspngibuyspy.asp =3D JOIN/QUIT | http://www.asplists.com/search =3D SEARCH Archives Reply to this message...        petroniu Well, I got two replies so far on my private address, and basically the idea is that m$ has already implemented a "Web Data Administrator". You can find it here: http://msdn.microsoft.com/code/default.asp?URL=/code/sample.asp?url=/MSDN-FI LES/026/002/458/msdncompositedoc.xml This is a pretty cool implementation which is made in two steps: 1) they implemented a so-called SqlAdmin namespace with different classes, one of them being SqlServer (among others being SqlDatabase, SqlTable, SqlColumn, SqlStoredProcedure). SqlServer class is based on SQL-DMO calls, being declared as: internal NativeMethods.ISqlServer dmoServer. Implementation is done in c#. 2) based on SqlAdmin above, they built a WebApp - also on c#. Still, somethings are missing as Ed pointed out: "Myself, I would love to see a web based app that can handle the triggers / SP'S and Indexes [ even simple ones ] ..." Any other comments? Regards, Petroniu "PPM" <Click here to reveal e-mail address> wrote in message news:697717@aspngibuyspy... [Original message clipped] Reply to this message...        Dave VanderWekke I think it is a great platform to build on. M$ has done most of the work and since they give you the code, you can add features to it. -----Original Message----- From: petroniu [mailto:Click here to reveal e-mail address] Sent: Thursday, August 15, 2002 4:12 AM To: aspngibuyspy Subject: [aspngibuyspy] Re: EM Module - feedback wanted Well, I got two replies so far on my private address, and basically the idea is that m$ has already implemented a "Web Data Administrator". You can find it here: http://msdn.microsoft.com/code/default.asp?URL=/code/sample.asp?url=/MSD N-FILES/026/002/458/msdncompositedoc.xml This is a pretty cool implementation which is made in two steps: 1) they implemented a so-called SqlAdmin namespace with different classes, one of them being SqlServer (among others being SqlDatabase, SqlTable, SqlColumn, SqlStoredProcedure). SqlServer class is based on SQL-DMO calls, being declared as: internal NativeMethods.ISqlServer dmoServer. Implementation is done in c#. 2) based on SqlAdmin above, they built a WebApp - also on c#. Still, somethings are missing as Ed pointed out: "Myself, I would love to see a web based app that can handle the triggers / SP'S and Indexes [ even simple ones ] ..." Any other comments? Regards, Petroniu "PPM" <Click here to reveal e-mail address> wrote in message news:697717@aspngibuyspy... [Original message clipped] | [aspngibuyspy] member Click here to reveal e-mail address = YOUR ID | http://www.asplists.com/asplists/aspngibuyspy.asp = JOIN/QUIT | http://www.asplists.com/search = SEARCH Archives Reply to this message...        petroniu Dave, I myself think that this is a great starter. I already added functionnality to fetch information about the views contained into a DB. It is quite straight-forward and I got it working in just about 3 hours, without knowing too much about the details of the actual implementation, but I figured out on the way. The only *nasty* part is that you need some information about the interfaces that you need to implement for the classes and objects from SQLDMO.dll, but I used my old Delphi copy to fetch the TLB information into a readable file (which BTW is about 2.4 Mb !). Since I am talking about this, do you know the '.net' way to get the description of interfaces from a COM server into a 'human readable' file? 'Cause if you add a reference to a COM server into your project, all you get is another dll (Interop)... Petroniu "Dave VanderWekke" <Click here to reveal e-mail address> wrote in message news:698381@aspngibuyspy... [Original message clipped] Reply to this message...     Ad MBR BootFX Best-of-breed application framework for .NET projects, developed by Matthew Baxter-Reynolds and MBR IT

Copyright © Matthew Baxter-Reynolds 2001-2008. '.NET 247 Software Development Services' is a trading style of MBR IT Solutions Ltd. Contact Us - Terms of Use - Privacy Policy - www.dotnet247.com