Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Import Access database to SQL Server 2005
Message
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01452152
Message ID:
01452154
Vues:
48
>Hi,
>
>I have a .mdb file (I guess this is an Access database) that someone sent me. I don't know the version of this Access database. I need to import it into my SQL Server 2005. I found an article on the web describing SSIS as a way to import the database. My primary concern is not to break anything in my SQL Server 2005. Is this (SSIS) method a safe and efficient method of importing Access into SQL Server? Or would you recommend another approach?
>
>TIA.

Go with SSIS. Create an extra database (staging) for now if you don't want to risk importing into your main database.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform