Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Convert Access 97 database to SQL server

 
   Database Help (Home) -> ODBC RSS
Next:  IIf statement  
Author Message
Hasi

External


Since: Oct 15, 2008
Posts: 1



(Msg. 1) Posted: Wed Oct 15, 2008 11:57 am
Post subject: Convert Access 97 database to SQL server
Archived from groups: microsoft>public>sqlserver>odbc (more info?)

Hi Guys,

I am trying to use Upsizing tool to convert Access 97 database to SQl server.

Can anyone help in this aspect?

Any help is appreciated...


Thanks,
Hasi

 >> Stay informed about: Convert Access 97 database to SQL server 
Back to top
Login to vote
Mary Chipman [MSFT]

External


Since: Feb 04, 2005
Posts: 31



(Msg. 2) Posted: Mon Oct 20, 2008 10:44 am
Post subject: Re: Convert Access 97 database to SQL server [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Here's some links to resources to get you started:

TechEd Online Panel:
Go to http://msdn.microsoft.com/en-us/events/teched/cc676818.aspx and
search for:
"Are we there yet? Successfully navigating the bumpy road from Access
to SQL Server"

Microsoft Access or SQL Server 2005: What's Right in Your
Organization?
http://www.microsoft.com/sql/solutions/migration/access/sql-or-access.mspx

Optimizing Microsoft Office Access Applications Linked to SQL Server
http://msdn.microsoft.com/en-us/library/bb188204.aspx

What are the main differences between Access and SQL Server?
http://sqlserver2000.databases.aspfaq.com/what-are-the-main-difference...etween-

"The Best of Both Worlds--Access MDBs and SQL Server"
http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp

SQL Server Migration Assistant for Access (SSMA for Access)
http://www.microsoft.com/sql/solutions/migration/access/default.mspx

FMS Upsizing Center
http://www.fmsinc.com/Consulting/sqlupsizedocs.aspx

Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/dp/0672319446

--Mary

On Wed, 15 Oct 2008 11:57:03 -0700, Hasi
wrote:

>Hi Guys,
>
>I am trying to use Upsizing tool to convert Access 97 database to SQl server.
>
>Can anyone help in this aspect?
>
>Any help is appreciated...
>
>
>Thanks,
>Hasi

 >> Stay informed about: Convert Access 97 database to SQL server 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
No Jet OLEDB provider to link an Access 2000 database to S.. - Hi all, I need to link a legacy Access 2000 database to SQL Server 2005 64 bits. My test server is a 32 bits XP running developer's version of SQL Server 2005 (32bits). In the object explorer Server/Server Objects/Linked Servers/Providers it lists..

Access linked to SQL Server - then web user querying Access - Hello I've created linked tables in Access to SQL Server using a DSN. The tables open fine in Access & I can edit data. However the same SQL queries scripted from a web server fail - this being a query of the tables in Access that are actually li...

Creating a Linked server to a tmberline database - Hi all, I have a Timberline construction application that I am trying to link to SQL server 2005 so I can import the data to SQL server for reporting services. I have created the linked server using the below CREATE LINK SERVER below and if I right..

sql server 2005 database in restore mode - Hi folks I was restoring a database in SQL Server 2005 express edition. Due to a malfunction, system restarted. Now when I try to access the database, the status shows as "Restoring Database". I have tried to restart SQL Server and PC, but ...

how to mapped the ms access db data to ms sql server - I need to create an ASP.Net page that connects to an MS SQL server as its dbase. But the MS SQL server is really connecting to an MS Access db to get the data.How can I mapped the data of the ms access db so that when my ms sql server connects it can....
   Database Help (Home) -> ODBC All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]