Showing posts with label req. Show all posts
Showing posts with label req. Show all posts

Sunday, February 19, 2012

Help Req: how to upgrade from MSDE to Standard Edition

I have Merge Publication with SQL Standard Edition publisher
and MSDE subscribers. Due to database size (1,8 GB) I'm preparing
to upgrade SQL Server subscribers from MSDE SP3a to Standard Edition.
Can I do this without breaking the subscription (i.e. simple upgrade),
or I have to unsubscribe , upgrade to SQL Standard Edition SP3a
and re-subscribe to publication.
What is the best practice ?
Any advice or link is appreciated.
Pagus
..
The best approach would be to backup the databases, upgrade, restore them,
and then do no sync (the subscriber already has the schema and data)
subscriptions.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Pagus" <pagus@.writeme.com> wrote in message
news:85dfm05hhog0h9h42v54vu2c81f95nn5pq@.4ax.com...
> I have Merge Publication with SQL Standard Edition publisher
> and MSDE subscribers. Due to database size (1,8 GB) I'm preparing
> to upgrade SQL Server subscribers from MSDE SP3a to Standard Edition.
> Can I do this without breaking the subscription (i.e. simple upgrade),
> or I have to unsubscribe , upgrade to SQL Standard Edition SP3a
> and re-subscribe to publication.
> What is the best practice ?
> Any advice or link is appreciated.
> Pagus
> .
|||I did it and it works fine.
Thank you Hilary !
On Sat, 9 Oct 2004 22:33:42 -0400, "Hilary Cotter"
<hilary.cotter@.gmail.com> wrote:

>The best approach would be to backup the databases, upgrade, restore them,
>and then do no sync (the subscriber already has the schema and data)
>subscriptions.

Help Req with Locking Tables...

Hi DB Gurus..

I need to lock one table ( table-level locking) as i dont want anyone to modify till i finish my stored procedure.

I need simple example on how to Lock the table and unlock..

Something like this

Lock Table Name...
...

statements go here
...

Unlock table...

Is this possible in Sql server 2000

waiting for ur replies..

Thanks in AdvanceI dont know whether this is efficient method

begin transaction

...

statements go here
...

Commit transaction|||Hey Guys..

anymore suggestions...|||Whenever I see anyone suggest locking a table, the first thing that comes to my mind is to stop SQL Server, then restart it in single user mode. While some folks consider this a bit drastic, it has about the same effect on scalability, it is far more efficient, and it is less uncertain.

-PatP