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.
Transferring table data from an ODBC database to a SQL Express database
Hot Topic
- Automatic client redirect in SQL Server 2005
- SQL Server does not exist or access denied
- Linking reports
- Install SQL 2005 to Cluster that has SQL 2000 installed
- IF statement with BEGIN END block
- External columns vs. output columns?
- Random access in a result set
- does not install SQL Query Analyzer
- RDF XML
- Using stored procedure or not?
SQL Server
- Exception of type 'System.OutOfMemoryException' was thrown. (Microsoft.SqlServer.SmoEnum)
- SSIS datatypes issue.
- How can I retrieve message strings from @@ERROR
- Disregard: SSIS as data source for reporting?
- DataAdapter.Update does not work with DataSet.Merge!!!!
- Couldn't connect to MSDE
- How to get programatic access to SSIS Service run time pkg monitoring info...?
- Manipulating SQL server databases dynamically
- Package Variable Names are Case Sensitive
- How to setup a dataflow which validates before writing to a destination ?
Transferring table data from an ODBC database to a SQL Express database
JohnT
glt
otgoo
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
mightymoe
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