Thank you. Very useful and simple.

32-bit software (SSMS, BIDS, etc) requires 32-bit Oracle Client. 64-bit software (SQL Server Database Engine)requires 64-bit Oracle client.

I haven't worked with Oracle 11, but this is the procedure I've used with previous Oracle versions. The little I saw of Oracle 11 before I left my previous job...

A good and tricky one. Thank you.

I tried once to figure this one out, but I didn't make it all the way. But if I remember correctly it had something to do with Kerberos and double...

No error codes?

I haven't tried to move a configuration.ini between Windows 7 and Windows Server 2008 R2, only between two Windows Server 2008 R2. But I see no reason why it shouldn't...

Is the linked server using the default port 1433? Otherwise you need to specify the port: @server = N'PC068751\SQLEXPRESS,<port>'

Thank you bitbucket-25253 and opc.three for this information.

I...

Are you doing it manually? The installation program should take care of this.

Me too!

I'm not an expert on this, but I can't see why this shouldn't work. Unless it's the same data replicated in both directions which means you're creating a loop.

The only time I had to backup an Express Edition I used the SQLMAINT tool.

See http://msdn.microsoft.com/en-us/library/ms162827(v=sql.105).aspx for reference.

Damn. Again. :angry: When will I learn to read the complete question/statement?

Good one. Keep 'em coming.