We are running SQL Srv 2000 Enterprise on a production SQL Server but are not
using the Enterprise features and want to conver to SQL Srv 2000 Standard.
Is it possible to "downgrade" without doing a full reinstall of SQL Srv?
I thought that was the answer based on what I have read but was holding out
some hope.
We currently own an Enterprise license but when we renew our yearly
agreement (We have educational pricing from MSFT), we wnat to remove that
license and use just standard.
"Immy" wrote:
> I'm afraid there is no option to downgrade.
> You'd need to backup your databases, uninstall and re-install the SQL
> server.
> Note that there is a cost different between Standard and Enterprise. Not
> sure you can get any refunds back from MS on this, so why don't you just
> keep the Ent. Edition installed if you've already paid for it. You may need
> the features in the future?
> Immy
> "jcs0277" <jcs0277@.discussions.microsoft.com> wrote in message
> news:D88E3328-FCA2-4ED5-B4FF-92BD0538769C@.microsoft.com...
>
>
|||i have a similar issue
i'm thinking of moving to the developer edition
does this move require uninstall then reinstall? is there more difference
between these editions than simply the license agreement?
"jcs0277" wrote:
[vbcol=seagreen]
> I thought that was the answer based on what I have read but was holding out
> some hope.
> We currently own an Enterprise license but when we renew our yearly
> agreement (We have educational pricing from MSFT), we wnat to remove that
> license and use just standard.
> "Immy" wrote:
Showing posts with label srv. Show all posts
Showing posts with label srv. Show all posts
Thursday, March 8, 2012
Convert SQL Srv 2000 Enterprise to SQL Srv Standard?
We are running SQL Srv 2000 Enterprise on a production SQL Server but are no
t
using the Enterprise features and want to conver to SQL Srv 2000 Standard.
Is it possible to "downgrade" without doing a full reinstall of SQL Srv?I'm afraid there is no option to downgrade.
You'd need to backup your databases, uninstall and re-install the SQL
server.
Note that there is a cost different between Standard and Enterprise. Not
sure you can get any refunds back from MS on this, so why don't you just
keep the Ent. Edition installed if you've already paid for it. You may need
the features in the future?
Immy
"jcs0277" <jcs0277@.discussions.microsoft.com> wrote in message
news:D88E3328-FCA2-4ED5-B4FF-92BD0538769C@.microsoft.com...
> We are running SQL Srv 2000 Enterprise on a production SQL Server but are
> not
> using the Enterprise features and want to conver to SQL Srv 2000 Standard.
> Is it possible to "downgrade" without doing a full reinstall of SQL Srv?|||I thought that was the answer based on what I have read but was holding out
some hope.
We currently own an Enterprise license but when we renew our yearly
agreement (We have educational pricing from MSFT), we wnat to remove that
license and use just standard.
"Immy" wrote:
> I'm afraid there is no option to downgrade.
> You'd need to backup your databases, uninstall and re-install the SQL
> server.
> Note that there is a cost different between Standard and Enterprise. Not
> sure you can get any refunds back from MS on this, so why don't you just
> keep the Ent. Edition installed if you've already paid for it. You may nee
d
> the features in the future?
> Immy
> "jcs0277" <jcs0277@.discussions.microsoft.com> wrote in message
> news:D88E3328-FCA2-4ED5-B4FF-92BD0538769C@.microsoft.com...
>
>|||i have a similar issue
i'm thinking of moving to the developer edition
does this move require uninstall then reinstall? is there more difference
between these editions than simply the license agreement?
"jcs0277" wrote:
[vbcol=seagreen]
> I thought that was the answer based on what I have read but was holding ou
t
> some hope.
> We currently own an Enterprise license but when we renew our yearly
> agreement (We have educational pricing from MSFT), we wnat to remove that
> license and use just standard.
> "Immy" wrote:
>
t
using the Enterprise features and want to conver to SQL Srv 2000 Standard.
Is it possible to "downgrade" without doing a full reinstall of SQL Srv?I'm afraid there is no option to downgrade.
You'd need to backup your databases, uninstall and re-install the SQL
server.
Note that there is a cost different between Standard and Enterprise. Not
sure you can get any refunds back from MS on this, so why don't you just
keep the Ent. Edition installed if you've already paid for it. You may need
the features in the future?
Immy
"jcs0277" <jcs0277@.discussions.microsoft.com> wrote in message
news:D88E3328-FCA2-4ED5-B4FF-92BD0538769C@.microsoft.com...
> We are running SQL Srv 2000 Enterprise on a production SQL Server but are
> not
> using the Enterprise features and want to conver to SQL Srv 2000 Standard.
> Is it possible to "downgrade" without doing a full reinstall of SQL Srv?|||I thought that was the answer based on what I have read but was holding out
some hope.
We currently own an Enterprise license but when we renew our yearly
agreement (We have educational pricing from MSFT), we wnat to remove that
license and use just standard.
"Immy" wrote:
> I'm afraid there is no option to downgrade.
> You'd need to backup your databases, uninstall and re-install the SQL
> server.
> Note that there is a cost different between Standard and Enterprise. Not
> sure you can get any refunds back from MS on this, so why don't you just
> keep the Ent. Edition installed if you've already paid for it. You may nee
d
> the features in the future?
> Immy
> "jcs0277" <jcs0277@.discussions.microsoft.com> wrote in message
> news:D88E3328-FCA2-4ED5-B4FF-92BD0538769C@.microsoft.com...
>
>|||i have a similar issue
i'm thinking of moving to the developer edition
does this move require uninstall then reinstall? is there more difference
between these editions than simply the license agreement?
"jcs0277" wrote:
[vbcol=seagreen]
> I thought that was the answer based on what I have read but was holding ou
t
> some hope.
> We currently own an Enterprise license but when we renew our yearly
> agreement (We have educational pricing from MSFT), we wnat to remove that
> license and use just standard.
> "Immy" wrote:
>
Convert SQL Srv 2000 Enterprise to SQL Srv Standard?
We are running SQL Srv 2000 Enterprise on a production SQL Server but are not
using the Enterprise features and want to conver to SQL Srv 2000 Standard.
Is it possible to "downgrade" without doing a full reinstall of SQL Srv?I'm afraid there is no option to downgrade.
You'd need to backup your databases, uninstall and re-install the SQL
server.
Note that there is a cost different between Standard and Enterprise. Not
sure you can get any refunds back from MS on this, so why don't you just
keep the Ent. Edition installed if you've already paid for it. You may need
the features in the future?
Immy
"jcs0277" <jcs0277@.discussions.microsoft.com> wrote in message
news:D88E3328-FCA2-4ED5-B4FF-92BD0538769C@.microsoft.com...
> We are running SQL Srv 2000 Enterprise on a production SQL Server but are
> not
> using the Enterprise features and want to conver to SQL Srv 2000 Standard.
> Is it possible to "downgrade" without doing a full reinstall of SQL Srv?|||I thought that was the answer based on what I have read but was holding out
some hope.
We currently own an Enterprise license but when we renew our yearly
agreement (We have educational pricing from MSFT), we wnat to remove that
license and use just standard.
"Immy" wrote:
> I'm afraid there is no option to downgrade.
> You'd need to backup your databases, uninstall and re-install the SQL
> server.
> Note that there is a cost different between Standard and Enterprise. Not
> sure you can get any refunds back from MS on this, so why don't you just
> keep the Ent. Edition installed if you've already paid for it. You may need
> the features in the future?
> Immy
> "jcs0277" <jcs0277@.discussions.microsoft.com> wrote in message
> news:D88E3328-FCA2-4ED5-B4FF-92BD0538769C@.microsoft.com...
> > We are running SQL Srv 2000 Enterprise on a production SQL Server but are
> > not
> > using the Enterprise features and want to conver to SQL Srv 2000 Standard.
> > Is it possible to "downgrade" without doing a full reinstall of SQL Srv?
>
>|||i have a similar issue
i'm thinking of moving to the developer edition
does this move require uninstall then reinstall? is there more difference
between these editions than simply the license agreement?
"jcs0277" wrote:
> I thought that was the answer based on what I have read but was holding out
> some hope.
> We currently own an Enterprise license but when we renew our yearly
> agreement (We have educational pricing from MSFT), we wnat to remove that
> license and use just standard.
> "Immy" wrote:
> > I'm afraid there is no option to downgrade.
> > You'd need to backup your databases, uninstall and re-install the SQL
> > server.
> > Note that there is a cost different between Standard and Enterprise. Not
> > sure you can get any refunds back from MS on this, so why don't you just
> > keep the Ent. Edition installed if you've already paid for it. You may need
> > the features in the future?
> > Immy
> >
> > "jcs0277" <jcs0277@.discussions.microsoft.com> wrote in message
> > news:D88E3328-FCA2-4ED5-B4FF-92BD0538769C@.microsoft.com...
> > > We are running SQL Srv 2000 Enterprise on a production SQL Server but are
> > > not
> > > using the Enterprise features and want to conver to SQL Srv 2000 Standard.
> > > Is it possible to "downgrade" without doing a full reinstall of SQL Srv?
> >
> >
> >
using the Enterprise features and want to conver to SQL Srv 2000 Standard.
Is it possible to "downgrade" without doing a full reinstall of SQL Srv?I'm afraid there is no option to downgrade.
You'd need to backup your databases, uninstall and re-install the SQL
server.
Note that there is a cost different between Standard and Enterprise. Not
sure you can get any refunds back from MS on this, so why don't you just
keep the Ent. Edition installed if you've already paid for it. You may need
the features in the future?
Immy
"jcs0277" <jcs0277@.discussions.microsoft.com> wrote in message
news:D88E3328-FCA2-4ED5-B4FF-92BD0538769C@.microsoft.com...
> We are running SQL Srv 2000 Enterprise on a production SQL Server but are
> not
> using the Enterprise features and want to conver to SQL Srv 2000 Standard.
> Is it possible to "downgrade" without doing a full reinstall of SQL Srv?|||I thought that was the answer based on what I have read but was holding out
some hope.
We currently own an Enterprise license but when we renew our yearly
agreement (We have educational pricing from MSFT), we wnat to remove that
license and use just standard.
"Immy" wrote:
> I'm afraid there is no option to downgrade.
> You'd need to backup your databases, uninstall and re-install the SQL
> server.
> Note that there is a cost different between Standard and Enterprise. Not
> sure you can get any refunds back from MS on this, so why don't you just
> keep the Ent. Edition installed if you've already paid for it. You may need
> the features in the future?
> Immy
> "jcs0277" <jcs0277@.discussions.microsoft.com> wrote in message
> news:D88E3328-FCA2-4ED5-B4FF-92BD0538769C@.microsoft.com...
> > We are running SQL Srv 2000 Enterprise on a production SQL Server but are
> > not
> > using the Enterprise features and want to conver to SQL Srv 2000 Standard.
> > Is it possible to "downgrade" without doing a full reinstall of SQL Srv?
>
>|||i have a similar issue
i'm thinking of moving to the developer edition
does this move require uninstall then reinstall? is there more difference
between these editions than simply the license agreement?
"jcs0277" wrote:
> I thought that was the answer based on what I have read but was holding out
> some hope.
> We currently own an Enterprise license but when we renew our yearly
> agreement (We have educational pricing from MSFT), we wnat to remove that
> license and use just standard.
> "Immy" wrote:
> > I'm afraid there is no option to downgrade.
> > You'd need to backup your databases, uninstall and re-install the SQL
> > server.
> > Note that there is a cost different between Standard and Enterprise. Not
> > sure you can get any refunds back from MS on this, so why don't you just
> > keep the Ent. Edition installed if you've already paid for it. You may need
> > the features in the future?
> > Immy
> >
> > "jcs0277" <jcs0277@.discussions.microsoft.com> wrote in message
> > news:D88E3328-FCA2-4ED5-B4FF-92BD0538769C@.microsoft.com...
> > > We are running SQL Srv 2000 Enterprise on a production SQL Server but are
> > > not
> > > using the Enterprise features and want to conver to SQL Srv 2000 Standard.
> > > Is it possible to "downgrade" without doing a full reinstall of SQL Srv?
> >
> >
> >
Tuesday, February 14, 2012
convert foxpro 3.0 table
Hi,
I've got about 6000 tables in foxpro 3.0 and a database in sql srv 2000.
now i've to convert the data of these 6000 tables into the database. the problem is that i have to convert all the tables seperatly!
is there a tool where i can convert these tables automatically?
i know it can with DTS, but the 6000 tables are divided over 1400 directories. So with DTS i can't convert them automatically.
does anyone know a solution?I dont see why not. Setup a string of load thru a query that loops. Try a complete import. I'm sure it can be done. You might want to test the process and do the conversion during off hours when there no other system activity.
Not a sermen
Just a thought|||I dont see why not. Setup a string of load thru a query that loops. Try a complete import. I'm sure it can be done. You might want to test the process and do the conversion during off hours when there no other system activity.
Not a sermen
Just a thought
so you are saying that i can loop through the directories with a DTS package?|||Yes, That's correct.
It may take some time to put together so doing manually depend on whether this process will need to be run multiple times??
I've got about 6000 tables in foxpro 3.0 and a database in sql srv 2000.
now i've to convert the data of these 6000 tables into the database. the problem is that i have to convert all the tables seperatly!
is there a tool where i can convert these tables automatically?
i know it can with DTS, but the 6000 tables are divided over 1400 directories. So with DTS i can't convert them automatically.
does anyone know a solution?I dont see why not. Setup a string of load thru a query that loops. Try a complete import. I'm sure it can be done. You might want to test the process and do the conversion during off hours when there no other system activity.
Not a sermen
Just a thought|||I dont see why not. Setup a string of load thru a query that loops. Try a complete import. I'm sure it can be done. You might want to test the process and do the conversion during off hours when there no other system activity.
Not a sermen
Just a thought
so you are saying that i can loop through the directories with a DTS package?|||Yes, That's correct.
It may take some time to put together so doing manually depend on whether this process will need to be run multiple times??
Subscribe to:
Posts (Atom)