Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Data Access

Transferring table data from an ODBC database to a SQL Express database

I am a SQL newbie. I have two connected databases that I work with in Visual Web Developer Express or Visual Basic Express. One is an ODBC master database that contains much table data and the other is my new destination sql express database. Where I was once very comfortable using the query grid in Access to accomplish almost anything with tables, it seems like now it is much more difficult. Can someone offer me some simplified advice on how to easily transfer the table data in the ODBC database tables to the sql express database. I have read sections on BCP and Bulk Insert but so far I have not figured out how to make it work. Any help or direction would be greatly appreciated.

[697 byte] By [JohnSavage] at [2008-3-7]
«« How to detect when a custom control is being used at design time?
»» Interacting with a database
# 1

Hi,

If you can have acces to a DTS in a SQLServer 200 installation, it would be more simple. Just use the DTS to transfer data from your ODBC Source to your SQLExpress. Its just like transfering data from and access database to a sqlserver 2000. But the relationship would not be copied. You would manually set the relationshipa again once the table is imported...

cheers,

Paul June A. Domag

PaulDomag at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Data Access...
# 2
Thanks for your reply! Is it safe to assume that there are not many resources in express editions for moving large quantities of data because that is not considered a developer function? I think I will give up the notion of moving large quantities of data until I have better resources.
JohnSavage at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Data Access...
# 3

Hi,

Yes, moving large quantity of data is a developer function. But, its not included in SQLExpress for once reason (IMHO) coz its free and it has limitations. You can try downloading the SQL Server 2005 CTP. It has a rich tools for administering a database...

cheers,

Paul June A. Domag

PaulDomag at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Data Access...
# 4
Thanks again for the information!
JohnSavage at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Data Access...
SQL Server
SQL Server Data Access

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified