Replication is exactly what you are looking for. Make sure you have PK's on your tables.

-tjm

Good. Did you try my code?

declare @STR varchar(500)

set @STR='bcp kroll..cdg9525_bri01208Training_Export in d:\_krollBat\AllData.txt -n -T -S meathead-pc\sqlexpress-e d:\_krollBat\err.txt'

print @STR

exec master..xp_cmdshell

Jack,

Do you know where I can find any SQL server (Stored Procedure, functions, query, etc) labs I can work on to better my development? Any recommendations or advice to...

Jack,

That is exactly what I needed! You are the man!

Let me review. I'll get back to you in the morning.

Thank you!

-tjm

Try a native BCP with an error output log. If it fails it will write to the log and you will get an understanding why...

declare @STR varchar(500)...

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

You cannot use upgrade to perform the following actions:

Reconfigure an existing installation of Integration Services.

Move from a 32-bit to a 64-bit version of SQL Server or from a...

We do use Excel from source and destination. We also do script SQL tasks. It is possible going from SQL 2005 32 bit to sql 2008 64 bit?

Jeff,

Just wanted to thank you again. That procedure has really come in handy in multiple scenarios.

-tjm

Thanks! Having one of those days....

Having a brain fart this morning. Where do I supply this parameter?

Msg 201, Level 16, State 4, Procedure GetDirDetails, Line 0

Procedure or function 'GetDirDetails' expects parameter '@piFullPath', which was...

Nope. Worked Great! Thanks for all your help!

Implemented and is already on production server. 😀

-tjm

Thank you. This looks interesting and I will implement into our development environment today and play around with it. When I copy your code, it pastes into...

What port is the server running on?

You can test the port via telnet

cmd:

telnet ip address port

eg telnet 192.168.1.123 1433

If you can make the connection, not a firewall...

Thank you. I just sent them an email. 🙂