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

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 importing/synching without replication

Author  Topic 

richnfamous
Starting Member

2 Posts

Posted - 2014-01-07 : 15:28:13
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

38200 Posts

Posted - 2014-01-07 : 15:45:46
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/
Go to Top of Page

richnfamous
Starting Member

2 Posts

Posted - 2014-01-07 : 16:18:04
thanks - i'll see if that's a viable option
Go to Top of Page
   

- Advertisement -