I'm doing some work for the clients who have SQL 2005 Small Business
versions.
I do not see Management Studio installed on their servers. On one of the
server I used a free version of Management Studio to attach database I
brought to install. Next time I needed to import data from another database
and it seems that Expess version doesn't support export/import.
I have a developer version of SQL 2005 with installation CD.
My questions:
1. Is it possible technically to run setup of SQL 2005 again in order to add
Management Studio (from developer version CD) when an initial installation
was Small Business version of SQL?
2. If yes, then is it legal? Everything I need is to setup some databases
and then I don't need that tool on the client server. Microsoft allows to
run a trial version within 180 days. I need this tool for a fiew hours.
3. If not, then is there any way to buy only a full version of Management
Studio, or download a trial full version of Management Studio and use it for
a fiew hours for a real work?

Any other suggestions how to manage SQL 2005 Small Business edition please

Thank you

vovan

WHy not have the client pony up the $49 for their own copy of developer
edition? That gives you full rights to use Management Studio on whatever
machine they install it...

--
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006






"vovan" <someone@vovan.com> wrote in message
news:OklaQ5OXHHA.1200@TK2MSFTNGP04.phx.gbl...
> I'm doing some work for the clients who have SQL 2005 Small Business
> versions.
> I do not see Management Studio installed on their servers. On one of the
> server I used a free version of Management Studio to attach database I
> brought to install. Next time I needed to import data from another
> database and it seems that Expess version doesn't support export/import.
> I have a developer version of SQL 2005 with installation CD.
> My questions:
> 1. Is it possible technically to run setup of SQL 2005 again in order to
> add Management Studio (from developer version CD) when an initial
> installation was Small Business version of SQL?
> 2. If yes, then is it legal? Everything I need is to setup some databases
> and then I don't need that tool on the client server. Microsoft allows to
> run a trial version within 180 days. I need this tool for a fiew hours.
> 3. If not, then is there any way to buy only a full version of Management
> Studio, or download a trial full version of Management Studio and use it
> for a fiew hours for a real work?
>
> Any other suggestions how to manage SQL 2005 Small Business edition please
>
> Thank you
>
> vovan
>

Thank you.
English is not my language and I do not understand you.
Is it possible to buy a developer edition for $49? I got mine from MSDN
subscription, the price for it is much much higher.

vovan

"Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:uoUHP9OXHHA.480@TK2MSFTNGP02.phx.gbl...
> WHy not have the client pony up the $49 for their own copy of developer
> edition? That gives you full rights to use Management Studio on whatever
> machine they install it...
>
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
>
>
>
>
>
>
> "vovan" <someone@vovan.com> wrote in message
> news:OklaQ5OXHHA.1200@TK2MSFTNGP04.phx.gbl...
>> I'm doing some work for the clients who have SQL 2005 Small Business
>> versions.
>> I do not see Management Studio installed on their servers. On one of the
>> server I used a free version of Management Studio to attach database I
>> brought to install. Next time I needed to import data from another
>> database and it seems that Expess version doesn't support export/import.
>> I have a developer version of SQL 2005 with installation CD.
>> My questions:
>> 1. Is it possible technically to run setup of SQL 2005 again in order to
>> add Management Studio (from developer version CD) when an initial
>> installation was Small Business version of SQL?
>> 2. If yes, then is it legal? Everything I need is to setup some databases
>> and then I don't need that tool on the client server. Microsoft allows to
>> run a trial version within 180 days. I need this tool for a fiew hours.
>> 3. If not, then is there any way to buy only a full version of Management
>> Studio, or download a trial full version of Management Studio and use it
>> for a fiew hours for a real work?
>>
>> Any other suggestions how to manage SQL 2005 Small Business edition
>> please
>>
>> Thank you
>>
>> vovan
>>
>
>

Thanks again,
I just checked Microsoft site and found there SQL Developer edition for $49

Thank you very much.

vovan

"Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:uoUHP9OXHHA.480@TK2MSFTNGP02.phx.gbl...
> WHy not have the client pony up the $49 for their own copy of developer
> edition? That gives you full rights to use Management Studio on whatever
> machine they install it...
>
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
>
>
>
>
>
>
> "vovan" <someone@vovan.com> wrote in message
> news:OklaQ5OXHHA.1200@TK2MSFTNGP04.phx.gbl...
>> I'm doing some work for the clients who have SQL 2005 Small Business
>> versions.
>> I do not see Management Studio installed on their servers. On one of the
>> server I used a free version of Management Studio to attach database I
>> brought to install. Next time I needed to import data from another
>> database and it seems that Expess version doesn't support export/import.
>> I have a developer version of SQL 2005 with installation CD.
>> My questions:
>> 1. Is it possible technically to run setup of SQL 2005 again in order to
>> add Management Studio (from developer version CD) when an initial
>> installation was Small Business version of SQL?
>> 2. If yes, then is it legal? Everything I need is to setup some databases
>> and then I don't need that tool on the client server. Microsoft allows to
>> run a trial version within 180 days. I need this tool for a fiew hours.
>> 3. If not, then is there any way to buy only a full version of Management
>> Studio, or download a trial full version of Management Studio and use it
>> for a fiew hours for a real work?
>>
>> Any other suggestions how to manage SQL 2005 Small Business edition
>> please
>>
>> Thank you
>>
>> vovan
>>
>
>

Aaron Bertrand [SQL Server MVP] (ten.xoc@dnartreb.noraa) writes:
> WHy not have the client pony up the $49 for their own copy of developer
> edition? That gives you full rights to use Management Studio on whatever
> machine they install it...

Does it? I mean, are the tools in Development Edition licensed for
production use?

As for the original post, I don't think the full-blown Mgmt Studio is
sufficient. You need Integration Services too to run export/import. Of
course, that is on the same 49$ CD, but it's still only licensed for
development.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

On Mar 2, 5:48 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> Aaron Bertrand [SQL Server MVP] (ten....@dnartreb.noraa) writes:
>
> > WHy not have the client pony up the $49 for their own copy of developer
> > edition? That gives you full rights to use Management Studio on whatever
> > machine they install it...
>
> Does it? I mean, are the tools in Development Edition licensed for
> production use?
>
> As for the original post, I don't think the full-blown Mgmt Studio is
> sufficient. You need Integration Services too to run export/import. Of
> course, that is on the same 49$ CD, but it's still only licensed for
> development.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Yes it is only meant for development.