March 17, 2009 at 10:03 am
I am migrating a table from Access to SQL Server. Well, i opened the mdb and exported the table through a Data Source and provided the name of the database.
Now, these tables are used to hold some buffer data during some key operations. These tables already have indexes and primary key mentioned inside the table.
Now, these are not appearing in the SQL counter parts. Do we need to apply them and how important it is to apply the indexes and constraints there?
Many Thanks...
March 17, 2009 at 10:31 am
It depends on the queries, but yes, indexes are extremely important. Most important is the clustered index. Here are several great articles on indexes by Gail Shaw [/url](GilaMonster). Even before that though, I'd suggest hitting the documentation in Books Online.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 17, 2009 at 10:56 am
MS has some good Migration assistant software for MSAccess, ...
Check out http://www.microsoft.com/Sqlserver/2005/en/us/migration.aspx
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
March 17, 2009 at 10:57 am
does there any technique exising to tranfer the indexes from access to sql counterparts?
March 17, 2009 at 2:23 pm
It has been a while since i tested with SSMA for access, but I think it has a section to handle this.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply