What is the suggested approach to Syncing/Backing up/Restoring from SQL Server 2008 to SQL Server 20
- by Eoin Campbell
I only have SQL Server 2008 (Dev Edition) on my development machine
I only have SQL Server 2005 available with my hosting company (and I don't have direct connection access to this database)
I'm just wondering what the best approach is for:
Getting the initlal DB Structure & Data into production.
And keeping any structural changes/data…