Showing posts with label release. Show all posts
Showing posts with label release. Show all posts

Monday, March 26, 2012

Migrating a db from SSE 2005 December CTP to SSE 2005 Release Version

I have a developer who built an application using the SSE 2005 December CTP and I would like to bring the db's into the official SSE 2005 released version. I have attempted the following:

1. Create the db's in the released version, detach and re-attach the CTP db's. I got an error telling me they were incompatible.

2. Installed CTP version on one server, backed up the db's and then attempted to restore the db's on another server running the official released version of SSE 2005. Got an error attempting that too.

3. Installed the Management Studio for SS 2005 Developer edition thinking that I could connect to the two seperate instances of each server and like I could in EM 2000 run the transfer wizard to move the db's and data from one server to the next. Problem with this is that I can't get an object browser connection established. I have TCP/IP all config'd correctly, too.

Any other ideas where I can go with this at this time?

Thanks in advance.

Bill

Often the easiest way to move databases is to do a Backup and Restore.|||

As you can see from # 2 of my attempts at this, that didn't work. Actual error was:

Database 'xyz' cannot be upgraded because its non-release version (590) is not supported by this version of SQL Server. You cannot open a database that is incompatible with this version of sqlservr.exe. You must re-create the database. (.Net SqlClient Data Provider)


|||

December CTP of what year? 590 is a pre-RTM version of SQL Server from well over a year ago. There is no way to upgrade this database to the current SP2 version, in fact I don't believe you could even open this database in RTM. The only way to move this database would be to go back to the version where it was created, script the database out to T-SQL and run the scripts on a released version of SQL Server.

Mike

sql

Migrating a db from SSE 2005 December CTP to SSE 2005 Release Version

I have a developer who built an application using the SSE 2005 December CTP and I would like to bring the db's into the official SSE 2005 released version. I have attempted the following:

1. Create the db's in the released version, detach and re-attach the CTP db's. I got an error telling me they were incompatible.

2. Installed CTP version on one server, backed up the db's and then attempted to restore the db's on another server running the official released version of SSE 2005. Got an error attempting that too.

3. Installed the Management Studio for SS 2005 Developer edition thinking that I could connect to the two seperate instances of each server and like I could in EM 2000 run the transfer wizard to move the db's and data from one server to the next. Problem with this is that I can't get an object browser connection established. I have TCP/IP all config'd correctly, too.

Any other ideas where I can go with this at this time?

Thanks in advance.

Bill

Often the easiest way to move databases is to do a Backup and Restore.|||

As you can see from # 2 of my attempts at this, that didn't work. Actual error was:

Database 'xyz' cannot be upgraded because its non-release version (590) is not supported by this version of SQL Server. You cannot open a database that is incompatible with this version of sqlservr.exe. You must re-create the database. (.Net SqlClient Data Provider)


|||

December CTP of what year? 590 is a pre-RTM version of SQL Server from well over a year ago. There is no way to upgrade this database to the current SP2 version, in fact I don't believe you could even open this database in RTM. The only way to move this database would be to go back to the version where it was created, script the database out to T-SQL and run the scripts on a released version of SQL Server.

Mike

Monday, March 12, 2012

Migrate Database from SQL Server 2005 beta 3 to Sql Server 2005 Release

Do you now, How can I move database with datas to release version of sql server?
Procedores backup/restore can't help becouse of unsuported version database.

Any ideas?What about generate a schema script? Then run an install of your schema in a new query. You could at least get the db schema but not the data.|||but I have many datas

Monday, February 20, 2012

Microsoft SQL Server Reporting Services

Hi all!
I have downloaded the new realese of SQL Server Reporting Services
(the real release, not the Beta 2) and gets the following error
whenever I try to build, deploy or preview a report. I even got it
when I try to shut down the Microsoft .Net IDE. Does anyone have a
clue?
I have used the beta 2 for a while now, without problem and I have
tried both to upgrade the beta 2 to this release and to uninstall the
beta 2 and install the new release from scratch with the same result.
Here is the error message I've got:
"Method not found: Void
Microsoft.DataWarehouse.Interfaces.MenuCommandEx.set_Input(System.Object[])"
Because I didn't find any group dedicated to Reporting Services I post
this message in a couple of more or less closely related groups. I
hope nobody minds.
Regards,
/Mattias TorngrenMat,
Please let me know if you get a resolution to this. I am getting the same er
ror.
Bob
-- Mat wrote: --
Hi all!
I have downloaded the new realese of SQL Server Reporting Services
(the real release, not the Beta 2) and gets the following error
whenever I try to build, deploy or preview a report. I even got it
when I try to shut down the Microsoft .Net IDE. Does anyone have a
clue?
I have used the beta 2 for a while now, without problem and I have
tried both to upgrade the beta 2 to this release and to uninstall the
beta 2 and install the new release from scratch with the same result.
Here is the error message I've got:
"Method not found: Void
Microsoft.DataWarehouse.Interfaces.MenuCommandEx.set_Input(System.Object[])"
Because I didn't find any group dedicated to Reporting Services I post
this message in a couple of more or less closely related groups. I
hope nobody minds.
Regards,
/Mattias Torngren|||The reporting services newsgroup went up early Tues 27 morning. It's
microsoft.public.sqlserver.reportingsvcs. Post there as it is being actively
monitored.
"Mat" <mattias_torngren@.hotmail.com> wrote in message
news:c7333b1a.0401280231.5843bba3@.posting.google.com...
quote:

> Hi all!
> I have downloaded the new realese of SQL Server Reporting Services
> (the real release, not the Beta 2) and gets the following error
> whenever I try to build, deploy or preview a report. I even got it
> when I try to shut down the Microsoft .Net IDE. Does anyone have a
> clue?
> I have used the beta 2 for a while now, without problem and I have
> tried both to upgrade the beta 2 to this release and to uninstall the
> beta 2 and install the new release from scratch with the same result.
> Here is the error message I've got:
> "Method not found: Void
>

Microsoft.DataWarehouse.Interfaces.MenuCommandEx.set_Input(System.Object[])"
quote:

> Because I didn't find any group dedicated to Reporting Services I post
> this message in a couple of more or less closely related groups. I
> hope nobody minds.
> Regards,
> /Mattias Torngren
|||I cannot find this microsoft.public.sqlserver.reportingsvcs newsgroup anywhe
re on the MSDN Newsgroup on the left nav bar for all the MSDN newsgroups
Venky|||Since it's a public newsgroup, it's hosted on the msnews.microsoft.com nntp
server .
I don't think there is a MSDN "managed" newsgroup as of yet.
"Venky" <anonymous@.discussions.microsoft.com> wrote in message
news:4785D4CD-E34F-48C3-BC6B-99FF6E32176A@.microsoft.com...
quote:

> I cannot find this microsoft.public.sqlserver.reportingsvcs newsgroup

anywhere on the MSDN Newsgroup on the left nav bar for all the MSDN
newsgroups
quote:

> Venky
|||You should be able to fix the problem by putting
Microsoft.DataWarehouse.Interfaces.DLL in the gac. (Try the gacutil
command line tool).
HTH,
Scott
http://www.OdeToCode.com
On 28 Jan 2004 02:31:39 -0800, mattias_torngren@.hotmail.com (Mat)
wrote:
quote:

>Hi all!
>I have downloaded the new realese of SQL Server Reporting Services
>(the real release, not the Beta 2) and gets the following error
>whenever I try to build, deploy or preview a report. I even got it
>when I try to shut down the Microsoft .Net IDE. Does anyone have a
>clue?
>I have used the beta 2 for a while now, without problem and I have
>tried both to upgrade the beta 2 to this release and to uninstall the
>beta 2 and install the new release from scratch with the same result.
>Here is the error message I've got:
>"Method not found: Void
>Microsoft.DataWarehouse.Interfaces.MenuCommandEx.set_Input(System.Object[])
"
>Because I didn't find any group dedicated to Reporting Services I post
>this message in a couple of more or less closely related groups. I
>hope nobody minds.
>Regards,
>/Mattias Torngren
|||I cannot find this reporting services newsgroup either !!|||and I don't know if it will become a "managed" newsgroup. I've asked the
microsoft.com site folks to get it listed out on
http://communities2.microsoft.com/c...s/default.aspx,
English/United States/Servers/SQL Server as that apparently got overlooked.
I've also started the conversation with technet and MSDN to see if we can
get it listed out on their sites.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Keith Hay" <demungkeith.hay@.attglobalperiodnet> wrote in message
news:Oy0uo%23b5DHA.2656@.TK2MSFTNGP11.phx.gbl...
quote:

> Since it's a public newsgroup, it's hosted on the msnews.microsoft.com

nntp
quote:

> server .
> I don't think there is a MSDN "managed" newsgroup as of yet.
>
> "Venky" <anonymous@.discussions.microsoft.com> wrote in message
> news:4785D4CD-E34F-48C3-BC6B-99FF6E32176A@.microsoft.com...
> anywhere on the MSDN Newsgroup on the left nav bar for all the MSDN
> newsgroups
>
|||Scott,
I have this same problem as Mat and the dll was already in the gac.
Bob
-- Scott Allen wrote: --
You should be able to fix the problem by putting
Microsoft.DataWarehouse.Interfaces.DLL in the gac. (Try the gacutil
command line tool).
HTH,
Scott
http://www.OdeToCode.com
On 28 Jan 2004 02:31:39 -0800, mattias_torngren@.hotmail.com (Mat)
wrote:
quote:

>Hi all!
>(the real release, not the Beta 2) and gets the following error
>whenever I try to build, deploy or preview a report. I even got it
>when I try to shut down the Microsoft .Net IDE. Does anyone have a
>clue?
>tried both to upgrade the beta 2 to this release and to uninstall the
>beta 2 and install the new release from scratch with the same result.
>Here is the error message I've got:
>Microsoft.DataWarehouse.Interfaces.MenuCommandEx.set_Input(System.Object[])
"
>this message in a couple of more or less closely related groups. I
>hope nobody minds.
>/Mattias Torngren
|||I've got an answer from another newsgroup that helped me. If you have
a beta installed than it's important to delete everything that has
with the reporting services to do before installing the new release,
otherwise you can get this problem.
The solution is to add an assembly to the gac like this:
"Add the file "C:\Program Files\Microsoft SQL
Server\80\Tools\ReportDesigner\Microsoft
.DataWarehouse.Interfaces.DLL"
to the GAC"
"You can do this from Start>Programs>Administrative Tools>Microsoft
.Net Framework 1.1 Configuration. Click on Assembly Cache and choose
Add an Assembly to the Cache"
You find the whole thread here:
http://www.sql-server-performance.c...p?TOPIC_ID=2963
Thank you again Jasper Smith
/Mattias Torngren
mattias_torngren@.hotmail.com (Mat) wrote in message news:<c7333b1a.0401280231.5843bba3@.posting.goo
gle.com>...
quote:

> Hi all!
> I have downloaded the new realese of SQL Server Reporting Services
> (the real release, not the Beta 2) and gets the following error
> whenever I try to build, deploy or preview a report. I even got it
> when I try to shut down the Microsoft .Net IDE. Does anyone have a
> clue?
> I have used the beta 2 for a while now, without problem and I have
> tried both to upgrade the beta 2 to this release and to uninstall the
> beta 2 and install the new release from scratch with the same result.
> Here is the error message I've got:
> "Method not found: Void
> Microsoft.DataWarehouse.Interfaces.MenuCommandEx.set_Input(System.Object[]
)"
> Because I didn't find any group dedicated to Reporting Services I post
> this message in a couple of more or less closely related groups. I
> hope nobody minds.
> Regards,
> /Mattias Torngren

Microsoft SQL Server Management Studio Express - Release Date?

Does anyone know if Microsoft has set a release date for Microsoft SQL Serve
r
Management Studio Express? I haven't been able to find any info on their we
b
site, so my guess is no.
Thanks,
JohnHi JohnJohn,
Last I saw just said early this year.
HTH,
Greg
"JohnJohn" <JohnJohn@.discussions.microsoft.com> wrote in message
news:23AE3017-67D0-4C0F-BFB1-66D1B08FADF5@.microsoft.com...
> Does anyone know if Microsoft has set a release date for Microsoft SQL
> Server
> Management Studio Express? I haven't been able to find any info on their
> web
> site, so my guess is no.
> Thanks,
> John

Microsoft SQL Server Management Studio Express - Release Date?

Does anyone know if Microsoft has set a release date for Microsoft SQL Server
Management Studio Express? I haven't been able to find any info on their web
site, so my guess is no. :)
Thanks,
JohnHi JohnJohn,
Last I saw just said early this year.
HTH,
Greg
"JohnJohn" <JohnJohn@.discussions.microsoft.com> wrote in message
news:23AE3017-67D0-4C0F-BFB1-66D1B08FADF5@.microsoft.com...
> Does anyone know if Microsoft has set a release date for Microsoft SQL
> Server
> Management Studio Express? I haven't been able to find any info on their
> web
> site, so my guess is no. :)
> Thanks,
> John

Microsoft SQL Server Management Studio Express - Release Date?

Does anyone know if Microsoft has set a release date for Microsoft SQL Server
Management Studio Express? I haven't been able to find any info on their web
site, so my guess is no.
Thanks,
John
Hi JohnJohn,
Last I saw just said early this year.
HTH,
Greg
"JohnJohn" <JohnJohn@.discussions.microsoft.com> wrote in message
news:23AE3017-67D0-4C0F-BFB1-66D1B08FADF5@.microsoft.com...
> Does anyone know if Microsoft has set a release date for Microsoft SQL
> Server
> Management Studio Express? I haven't been able to find any info on their
> web
> site, so my guess is no.
> Thanks,
> John