Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

upgrading from MSAccess

Status
Not open for further replies.
TonyKhela

TonyKhela

Technical User
May 7, 2002
157
GB
Hi All,
Anyone know of what tools to use and also of any good whitepapers on how to upgrade to SQL Server from Access?
thx
TK
 
Sort by date Sort by votes
Access provides an add-in which is an upsizing wizard. It works for tables; at least that's all I've ever used it for. Most other objects have to be recreated in some other application. MSSQL Server does not provide a screen development tool or formal report tool.

This doesn't cover all aspects of migration, just something to think about.
 
Upvote 0 Downvote

You may consider using a SQL Server DTS package (ie import) from Access data source to SQL Server. It does transfer the objects and data. I have noticed that autonumbers do not get set to identity columns in sql server.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

baran121
  • Locked
  • Question
take a database from system databse place
Replies
2
Views
339
iambob
iambob
RRinTetons
  • Locked
  • Question
Logging into a database using SSMS from non-domain machine
Replies
1
Views
387
fredericofonseca
fredericofonseca
intel233
  • Locked
  • Question
Backup/Restore DB from SQL issues
Replies
2
Views
157
intel233
intel233
duartevds
  • Locked
  • Question
Access SQL Server remotely from Another City 1
Replies
1
Views
126
gbaughma
gbaughma
tekpr00
  • Locked
  • Question
Capture and Replicate Changes from Source to Target.
Replies
0
Views
116
tekpr00
tekpr00

Part and Inventory Search

Sponsor

Back
Top