projecttoday
Programmer
How do I convert an Access 2002 backend database to SQL Server? Is there a tool for this? Or is that just in 2007? I have Access 2002 and SQL Server Express 2005.
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!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do I convert Access to SQL Server 1
- Thread starter projecttoday
- Start date
- Status
-
1
- #2
In Access2000 and Access2003 there's the Upsizing Wizard found in the Tools --> Database Utilities menu item.
I've never used Access2002 but considering it's in both the previous and subsequent versions, I would be very surprised if you don't find it in the same place.
I've never used Access2002 but considering it's in both the previous and subsequent versions, I would be very surprised if you don't find it in the same place.
- Thread starter
- #3
projecttoday
Programmer
What I am suposed to put in What SQL Server would you like to use for this database? I want to you this computer.
alvechurchdata
Programmer
Normally you ask the DBA in charge of the SQL Server database. If it's on your own machine then you use the name that you gave when you set up SQL Server. I was sure that the wizard gives you a list of servers to choose from.
Geoff Franklin
Geoff Franklin
- Status
Similar threads
- Question
- Locked
- Question
- Locked
- Question