Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

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

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?

Almighty SQL Goddess

38200 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

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

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  
 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.02 seconds. Powered By: Snitz Forums 2000