Has anyone had experience upsizing an access database to SQL Server?



I don't own a copy of SQL Server, but I was told that I can migrate an 

access database to an SQL Server database easily.  How do I make changes 

to the database once it has been upsized?  Is there a way to do it in 

Access or via a Web interface?



Any help anyone can give me would be greatly appreciated.

BASICALLY IS JUST LIKE USING A REGULAR ACCESS DATABASE, EXCEPT THE TABLES

ARE STORED ON THE SQL SERVER.  I SUGGEST YOU CONVERT THE DATABASE TO AN

ACCESS 2000 PROJECT DATABASE.  THEN YOU CAN LEARN SQL SERVER WHILE WORKING

IN ACCESS. 





Robert L. Rogers

Rexel Branch Electric

Application Developer

xxx-xxx-xxxx





-----Original Message-----

From: Kimberly Banks [mailto:lam_ashay@m...]

Sent: Thursday, December 20, 2001 4:29 PM

To: Access

Subject: [access] upsizing Access database to SQL Server





Has anyone had experience upsizing an access database to SQL Server?



I don't own a copy of SQL Server, but I was told that I can migrate an 

access database to an SQL Server database easily.  How do I make changes 

to the database once it has been upsized?  Is there a way to do it in 

Access or via a Web interface?



Any help anyone can give me would be greatly appreciated. 










****************************************************************************

******************************************************

This e-mail and any files transmitted with it are confidential and intended

solely for the use of the individual or entity to whom they are addressed.

If you have received this e-mail in error please notify the sender and

delete/destroy any copies.

****************************************************************************

******************************************************

Access2k and above comes with an upsizing feature...pretty straightforward,

actually.  You'll inevitably have to tweak somethings on the sql server.

And, SQL comes with tools for migrating data over from other data sources.



You'll want to familiarize yourself with the differences in Access and

SQL...data types, stored procs vs. Access queries, etc...And, you'll

probably have to work with any existing forms and reports to make them work

properly...if you're using them in Access.



A good book that might help you make a decision would be Wrox's very own

"SQL Server with Access 2000" by Rick Dobson.



Another good one...not by Wrox...is

"From Access to SQL Server" by Russell Sinclair



Both will give you a really good idea of what you're dealing with.

Darin



----- Original Message -----

From: "Kimberly Banks" <lam_ashay@m...>

To: "Access" <access@p...>

Sent: Thursday, December 20, 2001 9:28 PM

Subject: [access] upsizing Access database to SQL Server





> Has anyone had experience upsizing an access database to SQL Server?

>

> I don't own a copy of SQL Server, but I was told that I can migrate an

> access database to an SQL Server database easily.  How do I make changes

> to the database once it has been upsized?  Is there a way to do it in

> Access or via a Web interface?

>

> Any help anyone can give me would be greatly appreciated.




>

Hi Kimberly ,



We used SQL Upsizing Wizard to convert to Access97 database to SQL Server 

6.  It was easy and painless. The Wizard was, well, the "Wizard"....



____________________________________________________



John Fejsa

Systems Analyst/Computer Programmer

Hunter Centre for Health Advancement

Locked Bag 10

WALLSEND NSW 2287

Phone: (02) 49246 336 Fax: (02) 49246 209

____________________________________________________



The doors we open and close each day decide the lives we live

____________________________________________________



CONFIDENTIALITY & PRIVILEGE NOTICE

The information contained in this email message is intended for the named 

addressee only.  If you are not the intended recipient you must not copy, 

distribute, take any action reliant on, or disclose any details of the 

information in this email to any other person or organisation.  If you 

have received this email in error please notify us immediately.



>>> darin@r... 21/12/2001 8:38:13 >>>

Access2k and above comes with an upsizing feature...pretty straightforward,



actually.  You'll inevitably have to tweak somethings on the sql server.

And, SQL comes with tools for migrating data over from other data sources.



You'll want to familiarize yourself with the differences in Access and

SQL...data types, stored procs vs. Access queries, etc...And, you'll

probably have to work with any existing forms and reports to make them 

work

properly...if you're using them in Access.



A good book that might help you make a decision would be Wrox's very own

"SQL Server with Access 2000" by Rick Dobson.



Another good one...not by Wrox...is

"From Access to SQL Server" by Russell Sinclair



Both will give you a really good idea of what you're dealing with.

Darin



----- Original Message -----

From: "Kimberly Banks" <lam_ashay@m...>

To: "Access" <access@p...>

Sent: Thursday, December 20, 2001 9:28 PM

Subject: [access] upsizing Access database to SQL Server





> Has anyone had experience upsizing an access database to SQL Server?

>

> I don't own a copy of SQL Server, but I was told that I can migrate an

> access database to an SQL Server database easily.  How do I make changes

> to the database once it has been upsized?  Is there a way to do it in

> Access or via a Web interface?

>

> Any help anyone can give me would be greatly appreciated.




>










This message is intended for the addressee named and may contain confidential information. If you are not the intended recipient,
please delete it and notify the sender. Views expressed in this message are those of the individual sender, and are not necessarily
the views of Hunter Health.

I see the various comments on using the Upsizing tools etc.  I had a lot of

problems upsizing a database that functioned well in Access 97 and 2000.

Some of the tables would not upsize, especially ones with large numbers of

fields.  Others with a small number of fields would not import either for no

particular reason.  All had primary keys defined.  Can't remember the errors

but they were far from desriptive.



Anyone enlighten me on a few basic rules and definite 'faus pas' to avoid?



Thanks



Paul



-----Original Message-----

From: Kimberly Banks [mailto:lam_ashay@m...]

Sent: 20 December 2001 21:29

To: Access

Subject: [access] upsizing Access database to SQL Server





Has anyone had experience upsizing an access database to SQL Server?



I don't own a copy of SQL Server, but I was told that I can migrate an

access database to an SQL Server database easily.  How do I make changes

to the database once it has been upsized?  Is there a way to do it in

Access or via a Web interface?



Any help anyone can give me would be greatly appreciated.