SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 importing/synching without replication
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

richnfamous
Starting Member

2 Posts

Posted - 01/07/2014 :  15:28:13  Show Profile  Reply with Quote
sorry if this has been covered elsewhere...

i'm in the process of migrating two sites from shared servers to a decidated Win 2008 R2 which has SQL Express on it

the problem is that replication isn't available and i don't have access on the (current) shared server which will allow me to do a backup/restore to the new one. it's not a huge amount of data - 20-30 megs at the most

i have one db which was backed up a few days ago which needs to be synched with the current one, so we can take it offline, and another which i need to import completely

what would be the best way of going about a) synching the db that's been backed up and b) importing the second db completely?

tkizer
Almighty SQL Goddess

USA
37471 Posts

Posted - 01/07/2014 :  15:45:46  Show Profile  Visit tkizer's Homepage  Reply with Quote
If it's just 20-30MB, why not just do truncate/delete and then insert? It should be very fast for that amount of data. You could use a linked server for the insert.

Or truncate/delete plus bcp out/in.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

Edited by - tkizer on 01/07/2014 15:46:23
Go to Top of Page

richnfamous
Starting Member

2 Posts

Posted - 01/07/2014 :  16:18:04  Show Profile  Reply with Quote
thanks - i'll see if that's a viable option
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000