Showing posts with label specifically. Show all posts
Showing posts with label specifically. Show all posts

Monday, March 19, 2012

Can mirroring be implemented using SMO.

I wanted know that is it possible to implement mirroring in C#.NET framework using SMO (I need specifically a web applicaton). which willl provide a naive user the facilities integrated in SSMS. I am using VS.NET 2005 and SQL Server 2005 SP1.
Thanks and Regards,
Adii

Can you please clarify your question.

Database mirroring is a feature provided in "SQL Server 2005 SP1". Can you please elaborate what you mean by "implementing" it?

|||Thanks Sanjay,
I wanted to know that are there any classes or APIs provided, so that I can programmatically achieve mirroring in my application. Does SMO namespace can provide any assistance in this? Please do let me know if you know or find some solution for the same. I have SQL Server 2005 SP1 installed, but I don't want to use SSMS for doing mirroring. I want to provide this facility in my application to the user programmatically.|||I too am very interested in this answer. We are looking to automate some of the setup and configuration and it would be nice to be able to use SMO or some other exposed APIs to do it with.

Sunday, March 11, 2012

Can mirroring be implemented using SMO.

I wanted know that is it possible to implement mirroring in C#.NET framework using SMO (I need specifically a web applicaton). which willl provide a naive user the facilities integrated in SSMS. I am using VS.NET 2005 and SQL Server 2005 SP1.
Thanks and Regards,
Adii

Can you please clarify your question.

Database mirroring is a feature provided in "SQL Server 2005 SP1". Can you please elaborate what you mean by "implementing" it?

|||Thanks Sanjay,
I wanted to know that are there any classes or APIs provided, so that I can programmatically achieve mirroring in my application. Does SMO namespace can provide any assistance in this? Please do let me know if you know or find some solution for the same. I have SQL Server 2005 SP1 installed, but I don't want to use SSMS for doing mirroring. I want to provide this facility in my application to the user programmatically.|||I too am very interested in this answer. We are looking to automate some of the setup and configuration and it would be nice to be able to use SMO or some other exposed APIs to do it with.

Wednesday, March 7, 2012

Can I Use SQL Server 2005 Developer Edition For Client Tools?

My ISP has me licensed for a production SQL Server 2005 database, yet they
cannot provide me with the client tools that I need, specifically SQL Server
Management Studio and SQL Server Business Intelligence Development Studio.
If I purchase SQL Server 2005 Developer Edition will it have these two tools,
and will I be able to work with my production SQL database? Just for
clarification, I use the Business Intelligence studio to drop my existing
tables, and I migrate from locally-stored ACCESS databases to my production
SQL Server 2005 each night.On Jul 30, 3:46 pm, MIA Mark <MIAM...@.discussions.microsoft.com>
wrote:
> My ISP has me licensed for a production SQL Server 2005 database, yet they
> cannot provide me with the client tools that I need, specifically SQL Server
> Management Studio and SQL Server Business Intelligence Development Studio.
> If I purchase SQL Server 2005 Developer Edition will it have these two tools,
> and will I be able to work with my production SQL database? Just for
> clarification, I use the Business Intelligence studio to drop my existing
> tables, and I migrate from locally-stored ACCESS databases to my production
> SQL Server 2005 each night.
Yes, this should be fine. The licensing might be a bit of a gray area
though; but, I think that the ISP license should cover the production
deployment.
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
Regards,
Enrique Martinez
Sr. Software Consultant