SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Upsizing the Access Database into the SQL Server


Upsizing the Access Database into the SQL Server

Author
Message
Dinesh Asanka
Dinesh Asanka
SSCrazy
SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

Group: General Forum Members
Points: 2006 Visits: 223
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/dasanka/upsizingtheaccessdatabaseintothesqlserver.asp






My Blog: http://dineshasanka.spaces.live.com/
Tatsu
Tatsu
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1184 Visits: 307
I ran into a problem several years ago with the upsizing wizard. I don't remember the exact details but it had something to do with date/time fields. The problem was either caused by SQL Server having a more limited range of dates available in the datetime field that Access has in its equivalent or the Upsizing Wizard chose the smalldatetime when it should have picked the datetime data type. Regardless of the cause, the result was overflow-type errors when the wizard ran. So, if you run into errors like this, look at the data fields in the table that errors out and you'll probably find some data that won't fit into SQL Server for one of the above reasons.

Bryant E. Byrd, BSSE MCDBA MCAD
Business Intelligence Administrator
MSBI Administration Blog
Dave_D
Dave_D
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 1

This article has useful information, but aren't there article editors at SQL Server Central that review articles before they are posted for public consumption? The grammar is this article is very stilted, and in some cases completely inaccurate, making it difficult to read. While I certainly don't fault the author for not being totally fluent in English, I do think it reflects badly on the quality of the site. Even a cursory read-through should have resulted in the vast majority of mistakes being fixed by an editor.





Ned Noel
Ned Noel
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 4
Have read about six articles on this over the years. The English in this article is weak, but a lot better than my Chinese. The writer has done a good job of summarising the issues and two available upsizing tools with lots of practical information. Thanks to him for writing it. It helps.
Jim P.
Jim P.
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1495 Visits: 2215
The one that I found in upgrading is that the Yes/No has to translate to the smallint (not bit) if you are front-ending with Access 97. It may have changed in Acc2K. But the values for boolean field are 0 and -1. The bit is 0 to 255 with no negatives.



----------------
Jim P.

A little bit of this and a little byte of that can cause bloatware.
Tatsu
Tatsu
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1184 Visits: 307

Kathi must have read my post before she wrote her article on the Access Upsizing Wizard . She explains the problem I ran into and it looks like Access allows dates before 1753 and SQL Server does not. Kathi's article is at http://www.sqlservercentral.com/columnists/kKellenberger/accesstosqlservertheupsizingwizard.asp.



Bryant E. Byrd, BSSE MCDBA MCAD
Business Intelligence Administrator
MSBI Administration Blog
Dinesh Asanka
Dinesh Asanka
SSCrazy
SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

Group: General Forum Members
Points: 2006 Visits: 223

Very sorry for my porr english. I try to minize those in my next articles. Thank you very much for the comments. Its really helps me








My Blog: http://dineshasanka.spaces.live.com/
Tatsu
Tatsu
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1184 Visits: 307

No need to apologize, we all appreciate your effort and contribution to the community. I think Dave was a little harsher than he intended and his criticism was primarily aimed at our generous hosts. I think we need to step back and consider what has gone into building this community and give credit to our hosts for all the time and money they have put into this so that we can all benefit at no cost to us. I am sure that if some folks want to volunteer their time to do the proofreading the SQLServerCentral guys woud love the help.

Thanks Dinesh, keep the articles flowing!



Bryant E. Byrd, BSSE MCDBA MCAD
Business Intelligence Administrator
MSBI Administration Blog
Dinesh Asanka
Dinesh Asanka
SSCrazy
SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

Group: General Forum Members
Points: 2006 Visits: 223
Thankx Tatsu






My Blog: http://dineshasanka.spaces.live.com/
Steve Cooley
Steve Cooley
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 1
As I understand it, Access IS a RDBMS, but it is based on the JET engine rather than SQL and is only intended for a small number of users. Please correct your article, which states that Access is a "flat file" database.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search