Sql Enterprise Edition: moving

Showing posts with label moving. Show all posts

Monday, March 26, 2012

Enterprise SQL move to Standard

Is it possible to follow the steps of moving ALL db's from an Enterprise SQL
Server to a Standard SQL Server?
We would like to just stop the SQL services and move the DB's across, rename
the server to match the old server and start the new SQL server.
Will this work or will it break since we are going from Enterprise to
Standard?
--
Paul BergsonSee if this helps:
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
AMB
"Paul Bergson" wrote:
> Is it possible to follow the steps of moving ALL db's from an Enterprise SQL
> Server to a Standard SQL Server?
> We would like to just stop the SQL services and move the DB's across, rename
> the server to match the old server and start the new SQL server.
> Will this work or will it break since we are going from Enterprise to
> Standard?
> --
> Paul Bergson
>
>|||I have seen this. I want to know if I can move between Enterprise and
standard.
The bad thing about these newgroups is once someone answers in a thread a
lot of people no longer see them. So I will probably have to repost.
--
Paul Bergson MCT, MCSE, MCSA, CNE, CNA, CCA
This posting is provided "AS IS" with no warranties, and confers no rights.
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:F21A54AA-F591-4F4D-894B-806F1C9061C9@.microsoft.com...
> See if this helps:
> HOW TO: Move Databases Between Computers That Are Running SQL Server
> http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
>
> AMB
>
> "Paul Bergson" wrote:
> > Is it possible to follow the steps of moving ALL db's from an Enterprise
SQL
> > Server to a Standard SQL Server?
> >
> > We would like to just stop the SQL services and move the DB's across,
rename
> > the server to match the old server and start the new SQL server.
> >
> > Will this work or will it break since we are going from Enterprise to
> > Standard?
> >
> > --
> >
> > Paul Bergson
> >
> >
> >|||I think there is not a problem moving dbs between editions. At least there is
not a single comment in both KB articles, the one I posted and this one.
Moving SQL Server databases to a new location with Detach/Attach
http://support.microsoft.com/kb/224071/EN-US/
I have done it before (moving user dbs) between servers with diff edition,
and have not got any problem till now.
AMB
"Paul Bergson" wrote:
> I have seen this. I want to know if I can move between Enterprise and
> standard.
> The bad thing about these newgroups is once someone answers in a thread a
> lot of people no longer see them. So I will probably have to repost.
> --
> Paul Bergson MCT, MCSE, MCSA, CNE, CNA, CCA
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
> news:F21A54AA-F591-4F4D-894B-806F1C9061C9@.microsoft.com...
> > See if this helps:
> >
> > HOW TO: Move Databases Between Computers That Are Running SQL Server
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
> >
> >
> > AMB
> >
> >
> > "Paul Bergson" wrote:
> >
> > > Is it possible to follow the steps of moving ALL db's from an Enterprise
> SQL
> > > Server to a Standard SQL Server?
> > >
> > > We would like to just stop the SQL services and move the DB's across,
> rename
> > > the server to match the old server and start the new SQL server.
> > >
> > > Will this work or will it break since we are going from Enterprise to
> > > Standard?
> > >
> > > --
> > >
> > > Paul Bergson
> > >
> > >
> > >
>
>|||Shouldn't be a problem, since the real difference in the editions is things
like clustering support, log shipping, cpu and memory specs, etc. Its not
like DBCC Indexdefrag is going to be different in one edition vs. the
other...
Of course...you should be testing this in your lab anyway to confirm :-)
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
news:ua7SFT8VFHA.3176@.TK2MSFTNGP12.phx.gbl...
> Is it possible to follow the steps of moving ALL db's from an Enterprise
> SQL
> Server to a Standard SQL Server?
> We would like to just stop the SQL services and move the DB's across,
> rename
> the server to match the old server and start the new SQL server.
> Will this work or will it break since we are going from Enterprise to
> Standard?
> --
> Paul Bergson
>|||Ok
Thanks
--
Paul Bergson
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:#4y4ru8VFHA.1384@.TK2MSFTNGP09.phx.gbl...
> Shouldn't be a problem, since the real difference in the editions is
things
> like clustering support, log shipping, cpu and memory specs, etc. Its not
> like DBCC Indexdefrag is going to be different in one edition vs. the
> other...
> Of course...you should be testing this in your lab anyway to confirm :-)
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
> news:ua7SFT8VFHA.3176@.TK2MSFTNGP12.phx.gbl...
> > Is it possible to follow the steps of moving ALL db's from an Enterprise
> > SQL
> > Server to a Standard SQL Server?
> >
> > We would like to just stop the SQL services and move the DB's across,
> > rename
> > the server to match the old server and start the new SQL server.
> >
> > Will this work or will it break since we are going from Enterprise to
> > Standard?
> >
> > --
> >
> > Paul Bergson
> >
> >
>|||Ok
Thanks
--
Paul Bergson
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:09828E93-517B-47FE-8D3E-FE4017A12C1C@.microsoft.com...
> I think there is not a problem moving dbs between editions. At least there
is
> not a single comment in both KB articles, the one I posted and this one.
> Moving SQL Server databases to a new location with Detach/Attach
> http://support.microsoft.com/kb/224071/EN-US/
> I have done it before (moving user dbs) between servers with diff edition,
> and have not got any problem till now.
>
> AMB
> "Paul Bergson" wrote:
> > I have seen this. I want to know if I can move between Enterprise and
> > standard.
> >
> > The bad thing about these newgroups is once someone answers in a thread
a
> > lot of people no longer see them. So I will probably have to repost.
> >
> > --
> >
> > Paul Bergson MCT, MCSE, MCSA, CNE, CNA, CCA
> >
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> >
> > "Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in
message
> > news:F21A54AA-F591-4F4D-894B-806F1C9061C9@.microsoft.com...
> > > See if this helps:
> > >
> > > HOW TO: Move Databases Between Computers That Are Running SQL Server
> > > http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
> > >
> > >
> > > AMB
> > >
> > >
> > > "Paul Bergson" wrote:
> > >
> > > > Is it possible to follow the steps of moving ALL db's from an
Enterprise
> > SQL
> > > > Server to a Standard SQL Server?
> > > >
> > > > We would like to just stop the SQL services and move the DB's
across,
> > rename
> > > > the server to match the old server and start the new SQL server.
> > > >
> > > > Will this work or will it break since we are going from Enterprise
to
> > > > Standard?
> > > >
> > > > --
> > > >
> > > > Paul Bergson
> > > >
> > > >
> > > >
> >
> >
> >

Thursday, March 22, 2012

Enterprise Mgr Not showing Table permissions Correctly

After moving DB's to a new server, the public role was
removed on some, but not all of the tables. We tried
setting the permissions to public in EM but although it
correctly sets it, it does not appear to be set. So now
by using EM I can't tell which tables have the correct
permissions. Has anybody seen this problem where EM does
not correctly show the permissions? Does anyone know how
to resolve this? Also, can anyone show me a way to set
public permissions on all tables through QA?
ThanksYes, I've seen it before. It seems to be some disconnect between
syspermissions and sysprotects. I thought that a way to resolve it might be
to create a new database and copy the user tables into it and grant
permissions in the new database. However, I never got around to doing this.
Public is a role, what permissions would you want to grant to public? Select
to all tables?
GRANT SELECT
ON authors -- you could use a cursor here
TO public
Or, if you have your users already in a group, you could just add that group
to the db_datareader role (if you want everyone to have select).
<paul.j@.aptalaska.com> wrote in message
news:3bcc01c47f14$7f5002c0$a401280a@.phx.gbl...
> After moving DB's to a new server, the public role was
> removed on some, but not all of the tables. We tried
> setting the permissions to public in EM but although it
> correctly sets it, it does not appear to be set. So now
> by using EM I can't tell which tables have the correct
> permissions. Has anybody seen this problem where EM does
> not correctly show the permissions? Does anyone know how
> to resolve this? Also, can anyone show me a way to set
> public permissions on all tables through QA?
> Thankssql

Enterprise Manager...where do I get it?

Hi,
My company is moving to a new dedicated server and we are making the jump to
SQL Server. To start we are going to use the shared SQL server the hosting
company offers, our DB will be on the small side and we did not want to bog
down our new dedicated server.
But the problem is, where in the world do you get Enterprise Manager from?
We are a legit company, so we would prefer not downloading a trial version
of SQL Server, letting it expire and then just use Enterprise Manager.
Is it true that Enterprise Manager comes with Office XP Developers Edition?
Does it come with any other software that MS has that our IT dept. may have,
like MS Server?
Thanks!
MitchHow are you going to develop your software?
You will probably need a local database for that.
You can buy the developer edition (which includes e-m) for about =A350 I think.|||Correct me if I am wrong, but do I not develop the Database and Tables using
Enterprise Manager which is connected to the remote SQL Server at my host?
I would then develop my ASP pages using Macromedia Ultradev.
That seems to be the very same procedure I currently use when developing
with MS Access, except that the Database and Tables are developed locally
and then uploaded to the remote hosting server.
Am I missing something?
Mitch
"Nigel Rivett" <sqlnr@.hotmail.com> wrote in message
news:004001c3a08f$1abd0ab0$a101280a@.phx.gbl...
How are you going to develop your software?
You will probably need a local database for that.
You can buy the developer edition (which includes e-m) for
about £50 I think.

Monday, March 26, 2012

Enterprise SQL move to Standard

Enterprise SQL move to Standard

Enterprise SQL move to Standard

Thursday, March 22, 2012

Enterprise Mgr Not showing Table permissions Correctly

Enterprise Manager...where do I get it?

Sql Enterprise Edition

Blog Archive

About Me