migration from Beta 2 to Final edition

Will you please let me know how to have a smooth and NO DOWNTIME migration
from Beta 2 to Final version of SQL 2005? As per Microsoft, SQL 2005 final
version does not upgrade itself from Beta 2.
Thanks
John
I don't think there's any way to do a "smooth" migration. You cannot do an
in-place upgrade, so you'll have to do a side-by-side migration. I'm not
certain whether backed-up Beta 2 databases will restore on an RTM instance.
That's something you'll have to test on your end. Have you listened to any
of the migration webcasts? They discuss how to do side-by-side migrations
somewhat smoothly -- but no downtime might not be possible, depending on
your definition of that term.
Speaking of which, if you are running Beta 2 in production can we assume
that you're a TAP customer? Ask Microsoft for assistance.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
"John" <netconsul@.gmail.com> wrote in message
news:OX$3NSc9FHA.1420@.TK2MSFTNGP09.phx.gbl...
> Will you please let me know how to have a smooth and NO DOWNTIME migration
> from Beta 2 to Final version of SQL 2005? As per Microsoft, SQL 2005 final
> version does not upgrade itself from Beta 2.
> Thanks
> John
>

migration from Beta 2 to Final edition

Will you please let me know how to have a smooth and NO DOWNTIME migration
from Beta 2 to Final version of SQL 2005? As per Microsoft, SQL 2005 final
version does not upgrade itself from Beta 2.
Thanks
JohnI don't think there's any way to do a "smooth" migration. You cannot do an
in-place upgrade, so you'll have to do a side-by-side migration. I'm not
certain whether backed-up Beta 2 databases will restore on an RTM instance.
That's something you'll have to test on your end. Have you listened to any
of the migration webcasts? They discuss how to do side-by-side migrations
somewhat smoothly -- but no downtime might not be possible, depending on
your definition of that term.
Speaking of which, if you are running Beta 2 in production can we assume
that you're a TAP customer? Ask Microsoft for assistance.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"John" <netconsul@.gmail.com> wrote in message
news:OX$3NSc9FHA.1420@.TK2MSFTNGP09.phx.gbl...
> Will you please let me know how to have a smooth and NO DOWNTIME migration
> from Beta 2 to Final version of SQL 2005? As per Microsoft, SQL 2005 final
> version does not upgrade itself from Beta 2.
> Thanks
> John
>

migration from Beta 2 to Final edition

Will you please let me know how to have a smooth and NO DOWNTIME migration
from Beta 2 to Final version of SQL 2005? As per Microsoft, SQL 2005 final
version does not upgrade itself from Beta 2.
Thanks
JohnI don't think there's any way to do a "smooth" migration. You cannot do an
in-place upgrade, so you'll have to do a side-by-side migration. I'm not
certain whether backed-up Beta 2 databases will restore on an RTM instance.
That's something you'll have to test on your end. Have you listened to any
of the migration webcasts? They discuss how to do side-by-side migrations
somewhat smoothly -- but no downtime might not be possible, depending on
your definition of that term.
Speaking of which, if you are running Beta 2 in production can we assume
that you're a TAP customer? Ask Microsoft for assistance.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"John" <netconsul@.gmail.com> wrote in message
news:OX$3NSc9FHA.1420@.TK2MSFTNGP09.phx.gbl...
> Will you please let me know how to have a smooth and NO DOWNTIME migration
> from Beta 2 to Final version of SQL 2005? As per Microsoft, SQL 2005 final
> version does not upgrade itself from Beta 2.
> Thanks
> John
>

Migration 2005 beta to 2005 release

Hi Group,
Three quick questions about the 2005 beta.
1) Is it likely that restoring a 2005 beta database backup to a 2005
release environment (when it is released) will produce errors?
2) Will the .Net framework 1.1 be able to call SQL server 2005 beta
stored procedures?
3) Can I use Visual Studio .Net 1.1 to administer a SQL Server 2005
beta environment?
Cheers,
Stewart"Stewart" <windsurfing_stew@.yahoo.com.au> schrieb im Newsbeitrag
news:3e8a4d01.0504282031.4c10b786@.posting.google.com...
> Hi Group,
> Three quick questions about the 2005 beta.
> 1) Is it likely that restoring a 2005 beta database backup to a 2005
> release environment (when it is released) will produce errors?
There will be an whitepaper for the tap customers,perhpas that will be for
public download for release.

> 2) Will the .Net framework 1.1 be able to call SQL server 2005 beta
> stored procedures?
Sure.

> 3) Can I use Visual Studio .Net 1.1 to administer a SQL Server 2005
> beta environment?
Not sure, but I think thats possible, you only need to have to SQL Native
Client installed. I will try it on my box later.

> Cheers,
> Stewart
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--|||Hi
Just be aware, ADO.NET 1.1 does not support the new datatypes that exist in
SQL Server 2005.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Stewart" wrote:

> Hi Group,
> Three quick questions about the 2005 beta.
> 1) Is it likely that restoring a 2005 beta database backup to a 2005
> release environment (when it is released) will produce errors?
> 2) Will the .Net framework 1.1 be able to call SQL server 2005 beta
> stored procedures?
> 3) Can I use Visual Studio .Net 1.1 to administer a SQL Server 2005
> beta environment?
> Cheers,
> Stewart
>

Migration 2005 beta to 2005 release

Hi Group,
Three quick questions about the 2005 beta.
1) Is it likely that restoring a 2005 beta database backup to a 2005
release environment (when it is released) will produce errors?
2) Will the .Net framework 1.1 be able to call SQL server 2005 beta
stored procedures?
3) Can I use Visual Studio .Net 1.1 to administer a SQL Server 2005
beta environment?
Cheers,
Stewart
"Stewart" <windsurfing_stew@.yahoo.com.au> schrieb im Newsbeitrag
news:3e8a4d01.0504282031.4c10b786@.posting.google.c om...
> Hi Group,
> Three quick questions about the 2005 beta.
> 1) Is it likely that restoring a 2005 beta database backup to a 2005
> release environment (when it is released) will produce errors?
There will be an whitepaper for the tap customers,perhpas that will be for
public download for release.

> 2) Will the .Net framework 1.1 be able to call SQL server 2005 beta
> stored procedures?
Sure.

> 3) Can I use Visual Studio .Net 1.1 to administer a SQL Server 2005
> beta environment?
Not sure, but I think thats possible, you only need to have to SQL Native
Client installed. I will try it on my box later.

> Cheers,
> Stewart
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||Hi
Just be aware, ADO.NET 1.1 does not support the new datatypes that exist in
SQL Server 2005.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Stewart" wrote:

> Hi Group,
> Three quick questions about the 2005 beta.
> 1) Is it likely that restoring a 2005 beta database backup to a 2005
> release environment (when it is released) will produce errors?
> 2) Will the .Net framework 1.1 be able to call SQL server 2005 beta
> stored procedures?
> 3) Can I use Visual Studio .Net 1.1 to administer a SQL Server 2005
> beta environment?
> Cheers,
> Stewart
>

Migration 2005 beta to 2005 release

Hi Group,
Three quick questions about the 2005 beta.
1) Is it likely that restoring a 2005 beta database backup to a 2005
release environment (when it is released) will produce errors?
2) Will the .Net framework 1.1 be able to call SQL server 2005 beta
stored procedures?
3) Can I use Visual Studio .Net 1.1 to administer a SQL Server 2005
beta environment?
Cheers,
Stewart"Stewart" <windsurfing_stew@.yahoo.com.au> schrieb im Newsbeitrag
news:3e8a4d01.0504282031.4c10b786@.posting.google.com...
> Hi Group,
> Three quick questions about the 2005 beta.
> 1) Is it likely that restoring a 2005 beta database backup to a 2005
> release environment (when it is released) will produce errors?
There will be an whitepaper for the tap customers,perhpas that will be for
public download for release.
> 2) Will the .Net framework 1.1 be able to call SQL server 2005 beta
> stored procedures?
Sure.
> 3) Can I use Visual Studio .Net 1.1 to administer a SQL Server 2005
> beta environment?
Not sure, but I think thats possible, you only need to have to SQL Native
Client installed. I will try it on my box later.
> Cheers,
> Stewart
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--|||Hi
Just be aware, ADO.NET 1.1 does not support the new datatypes that exist in
SQL Server 2005.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Stewart" wrote:
> Hi Group,
> Three quick questions about the 2005 beta.
> 1) Is it likely that restoring a 2005 beta database backup to a 2005
> release environment (when it is released) will produce errors?
> 2) Will the .Net framework 1.1 be able to call SQL server 2005 beta
> stored procedures?
> 3) Can I use Visual Studio .Net 1.1 to administer a SQL Server 2005
> beta environment?
> Cheers,
> Stewart
>