Local MSDE export->Online SQL
I have a local MSDE (SQL Server 2005) on my local comp and I am developing it for a web server.
I am mostly done with the development, but now I have found that some tweaks are necessary on the local db and I would like to find an easier way to sync the data with the web server db?
Is there such as thing as:
Select from local db
Insert into web server db
I dont know if theres any option with SQL Server 2005 like there is with SQL 2000 DTS?
Vor lauter Bäumen den Wald nicht sehen.