Migrating beta 2 AS to beta 3 AS?

Hi,
Is there any suggestion to migrate beta 2 AS db to beta 3 AS db?
I tried to use backup and restore, and it did not work.
I have lots of MDX. I do not want to recreate AS in beta 3. U know, it is
lots of work from scratch.
Thanks,
Guangming
Strictly speaking there is no Beta 3.
I suspect you are out of luck but you might be better asking your
question on the microsoft.private.sqlserver2005.analysisservices.o lap
newsgroup.
Login information is located at
http://communities.microsoft.com/new...lcomePage.htm.
Andrew Watt
MVP - InfoPath
On Thu, 6 Oct 2005 10:42:01 -0700, Word 2003 memory Leakage
<Word2003memoryLeakage@.discussions.microsoft.com > wrote:

>Hi,
>Is there any suggestion to migrate beta 2 AS db to beta 3 AS db?
>I tried to use backup and restore, and it did not work.
>I have lots of MDX. I do not want to recreate AS in beta 3. U know, it is
>lots of work from scratch.
>Thanks,
>Guangming
|||I solved this problem by generating AS script in beta 2 and rerun it in beta 3.
THere is a beta 3. Not sure what you mean.
"Andrew Watt [MVP - InfoPath]" wrote:

> Strictly speaking there is no Beta 3.
> I suspect you are out of luck but you might be better asking your
> question on the microsoft.private.sqlserver2005.analysisservices.o lap
> newsgroup.
> Login information is located at
> http://communities.microsoft.com/new...lcomePage.htm.
> Andrew Watt
> MVP - InfoPath
> On Thu, 6 Oct 2005 10:42:01 -0700, Word 2003 memory Leakage
> <Word2003memoryLeakage@.discussions.microsoft.com > wrote:
>
>

Migrating beta 2 AS to beta 3 AS?

Hi,
Is there any suggestion to migrate beta 2 AS db to beta 3 AS db?
I tried to use backup and restore, and it did not work.
I have lots of MDX. I do not want to recreate AS in beta 3. U know, it is
lots of work from scratch.
Thanks,
GuangmingStrictly speaking there is no Beta 3.
I suspect you are out of luck but you might be better asking your
question on the microsoft.private.sqlserver2005.analysisservices.olap
newsgroup.
Login information is located at
[url]http://communities.microsoft.com/newsgroups/ICP/sqlserver2005/us/welcomePage.htm.[
/url]
Andrew Watt
MVP - InfoPath
On Thu, 6 Oct 2005 10:42:01 -0700, Word 2003 memory Leakage
<Word2003memoryLeakage@.discussions.microsoft.com> wrote:

>Hi,
>Is there any suggestion to migrate beta 2 AS db to beta 3 AS db?
>I tried to use backup and restore, and it did not work.
>I have lots of MDX. I do not want to recreate AS in beta 3. U know, it is
>lots of work from scratch.
>Thanks,
>Guangming|||I solved this problem by generating AS script in beta 2 and rerun it in beta
3.
THere is a beta 3. Not sure what you mean.
"Andrew Watt [MVP - InfoPath]" wrote:

> Strictly speaking there is no Beta 3.
> I suspect you are out of luck but you might be better asking your
> question on the microsoft.private.sqlserver2005.analysisservices.olap
> newsgroup.
> Login information is located at
> http://communities.microsoft.com/ne...ge.htm
.
> Andrew Watt
> MVP - InfoPath
> On Thu, 6 Oct 2005 10:42:01 -0700, Word 2003 memory Leakage
> <Word2003memoryLeakage@.discussions.microsoft.com> wrote:
>
>sql

Migrating Access to SQL Server

We use MS Access 2000 as our database, but run into lots of proplems. So we decided to research the migration to SQL Server.

I used Access Upsizing utitlity to migrate tables and their data to SQL server very easily, and all the relationships, indecies and other information are converted correctly.

Next is to migrate the queries. I found that to be a pain. Is there any tool out there that can do it for me? Any help is greatly appreciated.

Once that's done, then it's the application itself, but I am not worrying that for now.

Thanks, guysI don't have a tool to recommend.

Have you checked out the part of Microsoft's SQL Server 2000 Resource Kit that deal with migration?Chapter 5 - Migrating Access 2000 Databases to SQL Server 2000. There is a section called "Migrating Access Queries" you might find helpful.

Terri