July 21, 2011 at 11:42 am
Hi All
I have a this scenario.
Remote SQL
SQL 2008 R2
Local SQL
SQL 2008 R2
I have access to this remote server via Direct Access
I have access to copy some views from remote server but i can´t use Linked Sever to made a remote connection (for security reason).
are there any type of stored procedure or query to copy this tables?
Unfortunately i can´t use any kind of repplication mode for security reasons.
Thanks
July 21, 2011 at 12:54 pm
The only thing that comes to mind is BCP.
-Roy
July 21, 2011 at 12:59 pm
You mentioned views.
What exactly are you copying?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 21, 2011 at 1:10 pm
The SQL Admin generate a views from certain dba Tables.
I need to copy this views or the tables to a local SQL server.
July 21, 2011 at 1:35 pm
hugomaya (7/21/2011)
The SQL Admin generate a views from certain dba Tables.I need to copy this views or the tables to a local SQL server.
So do you just need to apply the schema for the views to the remote or do you need to create and populate the Base Tables and Data?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 21, 2011 at 2:20 pm
I need to create and populate the Base Tables and Data in my local SQL Server.
July 21, 2011 at 2:36 pm
hugomaya (7/21/2011)
I need to create and populate the Base Tables and Data in my local SQL Server.
Why not use SSIS?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 21, 2011 at 3:16 pm
Ok i go to try those both recomendations and see how it works. Tomorrow i write the results.
Thanks
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply