password99
Technical User
I have an Access DB that I want to convert to MSDE including data. How do I go about doing it using SQL Server Developer
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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MSDE
- Thread starter password99
- Start date
- Status
If you are using Access 2000, suggest that you familiarise yourself with the UpSizing Wazard. You'll get to this via the Tools, Database Utilities, Upsizing Wizard menu options.
This is a good starting point.
Another tool available form SQL Server install, and I think MSOffice Professional, is the "Import Export Data" tool, which allows you to transfer data between platforms.
Hope this helps,
Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
(dont cut corners or you'll go round in circles)
This is a good starting point.
Another tool available form SQL Server install, and I think MSOffice Professional, is the "Import Export Data" tool, which allows you to transfer data between platforms.
Hope this helps,
Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
(dont cut corners or you'll go round in circles)
I'd also suggest that you get the book "Microsoft Access Projects with Microsoft SQL Server" by Ralf Albrecht and Natascha Nicol. It's published by Microsoft and has their part #X08-42094.
It's an excellent reference book and guide to using Access Projects and both SQL Server and MSDE and includes excellent help on installing and using SQL Server.
Even if you are going to use Access rather than Access Project, I'd still highly recomment the book. It's the first reference I've found that even discusses MSDE to any great length and with worthwhile help. Worth the $60.
Bob
It's an excellent reference book and guide to using Access Projects and both SQL Server and MSDE and includes excellent help on installing and using SQL Server.
Even if you are going to use Access rather than Access Project, I'd still highly recomment the book. It's the first reference I've found that even discusses MSDE to any great length and with worthwhile help. Worth the $60.
Bob
- Status
Similar threads
- Locked
- Question