Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Upsizing the Access Database into the SQL Server Expand / Collapse
Author
Message
Posted Thursday, February 10, 2005 11:12 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 2:48 AM
Points: 912, Visits: 210
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/
Post #160892
Posted Monday, February 21, 2005 7:23 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, October 1, 2014 1:56 PM
Points: 295, Visits: 281
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
Post #163015
Posted Monday, February 21, 2005 10:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 13, 2006 9:44 AM
Points: 1, 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.




Post #163061
Posted Monday, February 21, 2005 1:28 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 4, 2009 1:56 AM
Points: 2, 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.
Post #163075
Posted Tuesday, February 22, 2005 7:10 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 7:42 PM
Points: 635, Visits: 2,215
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.
Post #163193
Posted Tuesday, February 22, 2005 7:24 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, October 1, 2014 1:56 PM
Points: 295, Visits: 281

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
Post #163196
Posted Friday, February 25, 2005 12:42 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 2:48 AM
Points: 912, Visits: 210

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/
Post #163964
Posted Friday, February 25, 2005 8:14 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, October 1, 2014 1:56 PM
Points: 295, Visits: 281

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
Post #164084
Posted Saturday, February 26, 2005 5:53 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 2:48 AM
Points: 912, Visits: 210
Thankx Tatsu






My Blog: http://dineshasanka.spaces.live.com/
Post #164282
Posted Wednesday, January 11, 2006 5:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 21, 2007 2:03 AM
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.
Post #249867
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse