InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 10:57:36 GMT20http://www.sqlservercentral.com/Forums/Topic1422270-391-1.aspx[quote][b]ajreynolds (2/20/2013)[/b][hr]I occasionally have need to export data from a MSSQL database to a file, copy the file to another server on a different network, then import the data from the file into a different MSSQL database. In the past I've done this by exporting the data to an Access database file, but on newer machines with Office 2010, Access isn't included. Sometimes I need to do large amounts of data from many tables, so using a flat file or Excel wouldn't work well. What would be the recommended way to handle this sort of thing?Thanks,Andy[/quote]create a new databasecopy the tables to itdetach it/back it upcopy it to remote serverattach it/restore it copy data to desired locationThis can of course be scripted as well, just to make life simpler.Wed, 20 Feb 2013 16:47:43 GMTmister.magoohttp://www.sqlservercentral.com/Forums/Topic1422270-391-1.aspxDepending on what is meant by "copy the file to another server on a different network", bcp may run into permissions issues.I'd take a look at using SSIS for this and make a package to do the work for you. It may have a steeper learning curve than BCP but it can be more flexible.Wed, 20 Feb 2013 15:57:54 GMTScott D. Jacobsonhttp://www.sqlservercentral.com/Forums/Topic1422270-391-1.aspxYou should use bcp utility. It is included as apart of every SQL Server installation. It is a command line utility, you specify what data is to be exported via command line parameters to a given file, then you can use bcp to bulk insert the same file to a table on the destination server.There are lots of command line option and you can look up the details in BOL but in the simplest case, going from SQL server to SQL Server you can use:output:bcp "select query" queryout destFilePath -k -N -Sserver -Tinput at destination:bcp dbname.dbo.tablename in destFilePath -E -k -N -Sserver -TWed, 20 Feb 2013 13:26:46 GMTsturnerhttp://www.sqlservercentral.com/Forums/Topic1422270-391-1.aspxI occasionally have need to export data from a MSSQL database to a file, copy the file to another server on a different network, then import the data from the file into a different MSSQL database. In the past I've done this by exporting the data to an Access database file, but on newer machines with Office 2010, Access isn't included. Sometimes I need to do large amounts of data from many tables, so using a flat file or Excel wouldn't work well. What would be the recommended way to handle this sort of thing?Thanks,AndyWed, 20 Feb 2013 13:11:58 GMTajreynolds