To update a database, attach (or restore) the files on the higher version server. If you are looking to upgrade your entire instance, then run the Upgrade Advisor, and then...

http://msdn.microsoft.com/en-us/library/ms174763.aspx

I don't want a cookie. Not really my thing.

Now this....

Why not take your full backup and restore it on the remote instance? Depending on activity, the VSS service can be problematic. You are attempting to freeze two files and...

All good suggestions. ultimately you cannot start a remote job from your local SQL Server instance without opening a connection on the other instance. Your instance has no control over...

If you don't need this in a single transaction, you can try updating batches of rows. Sometimes that is quicker than one large update.

Can you post the error?

Mean editor?

Too slow! Removing a lot of SPAM this morning, and disabling some accounts.

Beer[/url]

I believe when you run this that the SQL Server service account might need rights to the destination.

Removed. Not likely to get responses now.

Merge or Bidirectional transactional will help. However you might end up spending a lot of time trying to resolve conflicts and issues. Are you talking about moving some tables and/or...

IMHO, adding data to development so as not to mess up production is a bad idea. You'll start to think that you don't have to be as careful because its'...

'postro-fees are also used to show a bit o' an accent.