Bob, let me start by thanking you for all your advise.

This kind of things makes me jumpy, just because it is Terra incognita.

I have spent the best part of the...

In Programs and features there is a program called "Microsoft SQL Server Data tools - Database projects - web installer entry point".

I guess that is the program you are referring...

Yes,

I can go to "all programs / Microsoft SQL Server 2012 / SQL Server Data Tools"

I can also go to "all programs / Microsoft SQL Server 2012 / Microsoft Visual...

Hi Bob,

Thanks for your reply.

You are right about the SSIS / data tools.

If I start data tools (or start visual studio 2010, which is I believe the same), start a...

Hi Koen

Thanks for your reply,

In the list of available SQL Server programms there is an option to go to Visual studio 2010. This, however, leads me to the same program...

Thamks Koen

I will try your solution

Hein

OK, sounds do-able

I will purchase this edition

Maybe an additional question: like I mentioned in my 1st thread: I have created a linked server to another database (mySQL)

If I install the...

Hi Lynn

Thanks for your reply

I have installed the file: SQLEXPRADV_x64_ENU as found on the SQL Server site

So I guess that is the Express version?

Hein

Hi Louis

Thanks for the update!

As said SQL Server is new to me.

I have found the Import and export data (64 bit) option in SQL Server

I understand that this is...

Hi Lowell

Thanks for putting me on the right track (SQL Server is new to me, let alone a linked server).

You made me realise that only the query part concerning the...

Hi Louis,

Thanks for your reply

I have changed the code to:

select * from openquery(COVAS,'

INSERT INTO [CovasCopy].[dbo].[Countries].[Country]

SELECT [cntNameISU] FROM [Covas].[db_covas].[tblCountries]')

This gives me the error message:

Msg 7357, Level 16, State...

Hi Koen

Thx, I have found it (and changed the settings of course 😛 )

Thanks again

Hein

Hi Koen

Thx for your reply

Changing the settings to 50 threads at once will make reading it all a bit easier

I have looked for the place to change it but can't...

Very helpful George 🙂

Thank you for it.

I am sure this will help me on my way / quest.

Hein

Thanks George for your reply,

Between Steve's reply and yours I have answered Steve's.

In understand now what the .frm, .myd and .myi extensions are.

What I apparently want to do is the...