Migrate from Access to MSDE

Hi,
We have been using VB and Access to collect our date for several years.
Now our Access database is reaching 2 gb and we will soon have to switch to
sql server.
As intermediate step I downloaded MSDE2000 relA and istalled it.
I tried to use "Upsizing Wizard" but at the end, even if let me go trough to
process, it does not create the project file.
What do I do wrong?
Thank you
You have the same size limitations in MSDE as you do in Access. Your
MSDE database will actually be larger than it would be in Access due
to the increased overhead involved in SQL Server, but it's not clear
if that is a problem or not since you have not posted any error
messages. You can get more information about the upsizing wizard and
its many points of failure from the upsizing whitepaper, available at
http://support.microsoft.com/default...en-us;q294407.
--Mary
On Thu, 26 Aug 2004 11:39:06 -0700, "WilliamD"
<WilliamD@.discussions.microsoft.com> wrote:

>Hi,
>We have been using VB and Access to collect our date for several years.
>Now our Access database is reaching 2 gb and we will soon have to switch to
>sql server.
>As intermediate step I downloaded MSDE2000 relA and istalled it.
>I tried to use "Upsizing Wizard" but at the end, even if let me go trough to
>process, it does not create the project file.
>What do I do wrong?
>Thank you
|||I know about size limitations, but I would like to get more familiar with
SQLServer (before we have to migrate in few months), using MSDE. Then I
believe it would take no effort to migrate to SQL Server, is that right?
I tried Upsizing Wizard with a small database with only 2 tables. I did get
no error message, but Access did not created the project file. Into the
upsizing report, that is created at the end, for each table it says "skipped".
"Mary Chipman" wrote:

> You have the same size limitations in MSDE as you do in Access. Your
> MSDE database will actually be larger than it would be in Access due
> to the increased overhead involved in SQL Server, but it's not clear
> if that is a problem or not since you have not posted any error
> messages. You can get more information about the upsizing wizard and
> its many points of failure from the upsizing whitepaper, available at
> http://support.microsoft.com/default...en-us;q294407.
> --Mary
> On Thu, 26 Aug 2004 11:39:06 -0700, "WilliamD"
> <WilliamD@.discussions.microsoft.com> wrote:
>
>
|||Hi William,
I'd strongly suggest you get a copy of the developer edition of sql server.
It's about $49 USD and provides a whole raft of tools that will be useful to
you. You might have more luck using SQL Enterprise Manager to import your
tables, etc. from your Access databases. You get a lot more control and can
see a lot more of what's going on.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"WilliamD" <WilliamD@.discussions.microsoft.com> wrote in message
news:AFE56A8D-9A3C-4E00-AB07-52D07D986C0A@.microsoft.com...
> I know about size limitations, but I would like to get more familiar with
> SQLServer (before we have to migrate in few months), using MSDE. Then I
> believe it would take no effort to migrate to SQL Server, is that right?
> I tried Upsizing Wizard with a small database with only 2 tables. I did
get
> no error message, but Access did not created the project file. Into the
> upsizing report, that is created at the end, for each table it says
"skipped".[vbcol=seagreen]
> "Mary Chipman" wrote:
switch to[vbcol=seagreen]
trough to[vbcol=seagreen]
|||Did you read the upsizing whitepaper? It tells you why the wizard
skips tables, which it does for a myriad of reasons. I'd definitely
follow Greg's recommendation to purchase the Developer edition to
familiarize yourself with SQL Server. You can use it to develop a
solution which you then deploy using MSDE (the license agreement
prohibits using the Dev edition on a production server). Access/MSDE
alone do not have the capability to develop applications and neither
are much use in learning SQL Server.
--Mary
On Mon, 30 Aug 2004 16:51:03 -0700, "WilliamD"
<WilliamD@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>I know about size limitations, but I would like to get more familiar with
>SQLServer (before we have to migrate in few months), using MSDE. Then I
>believe it would take no effort to migrate to SQL Server, is that right?
>I tried Upsizing Wizard with a small database with only 2 tables. I did get
>no error message, but Access did not created the project file. Into the
>upsizing report, that is created at the end, for each table it says "skipped".
>"Mary Chipman" wrote:

migrate flat files into databases

From: lpatel5@.yahoo.com (Lina)
Newsgroups: microsoft.public.sqlserver.ce
Subject: Migration of Flat Files
Date: 26 Jun 2003 07:28:12 -0700
What is the best design approach for migrating about 1000 Flat files
from legacy applications to a single or multiple relational
database(s) on SQL Sever?
These files are not delimeted or in any fixed format.
Thank YouWhat you are asking for is almost magic. You have to have some structure in
each file or it cannot be imported into a relational database with a
row-column table structure. You may want to check with the legacy system to
see if it can export to a structured (delimited or fixed format) file. The
only exception is where each single file maps to a field in an individual
row in the database such as an image file mapping to an image datatype.
Then you will have to generate additional columns to capture file name and
date information if that is meaningful information.
If each file maps to an individual table, then you will need to generate the
table structure and then parse each file file into each table. BCP and/or
DTS are the tools to do that job. If multiple files can map to the same
table, you will likely have to add elements to the table to indicate which
file, since that information is probably meaningful to the system. In that
case, DTS is probably your best bet since it is more flexible.
Any way you look at this, it is not an easy task. Again, check and see if
there is an export utility for your legacy app that can get you to a format
that is easily imported.
Good Luck.
--
Geoff N. Hiten
Senior Database Administrator
Careerbuilder.com
"Amy Yuan [MS]" <amyy@.online.microsoft.com> wrote in message
news:00H8TwaRDHA.1060@.cpmsftngxa09.phx.gbl...
> From: lpatel5@.yahoo.com (Lina)
> Newsgroups: microsoft.public.sqlserver.ce
> Subject: Migration of Flat Files
> Date: 26 Jun 2003 07:28:12 -0700
> What is the best design approach for migrating about 1000 Flat files
> from legacy applications to a single or multiple relational
> database(s) on SQL Sever?
> These files are not delimeted or in any fixed format.
> Thank You
>

microsoft.reporting .rdlc

Hi I am trying to make a scatter chart with the reportviewer and report built into Visual Studio 2005

In my dataset it's basically a date and a value like

3/2/2005 10000

3/4/2005 12000

3/7/2005 9000

So I set the chart to use the Date on the X axis and the number on the Y axis

the report generates but on the X axis all the dates are converted to some integer value and it doesn't display it in date format, how do i get it to show in date format?

I think it takes the date and makes it an integer so it can display all the ticks for it for the dates that are not in my dataset that lie inbetween the dates that are.

Hii, I dont know what chart you are using, but you will have to use the CustomProperty in the charts <CustomProperties>,

For dundas chart the rdl looks like this -

<CustomProperties>

<CustomProperty>

<Name>Chart.ChartAreas.0.ChartArea.AxisX.ValueType</Name>

<Value>Date</Value>

</CustomProperty>

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