>>>>First, thank you. But these SQL Server databases are on different servers (different companies). So I don't think the above syntax will work.
>>>
>>>How many records? If low, you can script them and run the script on the database #2.
>>
>>The number of records is not that great (probably less than 1000). I didn't realize that you can script the table with the values (I thought script is for creating the structure of a table). Do you remember/have an example of a syntax of such script?
>>Thank you.
>
>SSMS
>Right Click on Database and select Tasks->Create Scripts
>Follow the wizard.
>Click on Advanced button when Set Scripting options screen appear.
>Scroll down to Types of data to script and select Schema and Data.
I don't see Advanced button. I am using SQL Server 2008 R2. I see a different way to do it.
Here is what I am doing:
Right mouse click on the database -> Tasks -> Generate Scripts (I don't see Create Scripts) -> Choose Script Options -> Table View Options -> Script Data. Default is False; I change it to True.
Then I can select the table and output script to the window.
Is this the way you were suggesting?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham