>I have to SQL Databases with the same exact tables. I'll call one new_data and the other source_data. I want to transfer data from nine of the tables in my source_data database into tables of the same name in my new_data database.
>
>I'm not sure how to properly begin. I have created a project with a database container. I have setup two new data sources in my ODBC Manager and two new connections, one to each data source.
>
> Do I want to use Updateable Remote Views to do this?
>
>I was going to create Remote Views for each of the tables that need to be updated in my new_data database, but I don't know if that's what I want to do. I'm not sure of the SQL statements I want to use. This is not part of an application. I'm just needing a quick way to transfer the data from the old database into the new one.
>
>Thank you for the help.
Elgin,
If it's not part of an application (might be) then directly use SQL server tools like DTS or backup and restore.
With ODBC you'd connect to SQL server and have your commands with fully qualified paths. ie:
insert into NewDb..Table1 Select * from OldDb..Table1
Cetin