>>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
I'm using MSDE. I do not have SQL Server nor Enterprise Manager. Can you briefly tell me what DTS is?
My source database is d:\c-srv\aa\hoasource.mdf and my new database base is d:\c-srv\aa\hoa_data.mdf.
Can you clarify that INSERT INTO command? I would like to learn this syntax and expand on it, as I may develop a simple app for my own use in the future.
Thank you for you kind assistance.