Synch Local database with hosted database SQL2008

I would like to update the hosted SQL2005 database on a scheduled basis from a local SQL 2005 database. Automatically without having to log into the discountasp.net site.

How do I go about doing this?

Thanks,

Roger

 

Hi,
How about the Import/Export wizards in SQL Server?
They do a good job and you can create a little SQL code to catch any errors or duplicates.
All the best,
Mark

 

So how would I automate this?

Also can I run this kind of stuff from the local pc and put data on the Discountasp.net server this way?

How is the connection between the two done?

Rog

 

...I can create Webcasts for this sort of thing but it varies for SQL Server versions.
The best option will be for you to give SQL Server 2008 a try.
You can use the free Express versions, they do more than the previous Express versions in SQL Server 2005 or 2000 did.
Are you good with SQL code? Willing to give SQL Server 2008 a chance?
If so I can offer a lot more help with this.
All the best,
Mark

 

Why the push to SQL 2008?

Here where I work we are only at 2005 and many other applications are utilizing it, so upgrading to 2008 really isn't an option unfortunately.

I am thinking it should be easy as selecting data from the local database into the Remote discountasp.net database? Maybe with some scheduled jobs / stored procedures this can be done?

I am versed in TSQL.

Rog

 

...No push to SQL Server 2008 but using it locally for a remote SQL Server 2005 account is very handy.
Right now the R2 versions of SQL Server 2008 Enterprise and Express are out, with loads of new features.

Even if working with remote SQL Server 2005 accounts I'd personally use 2008 locally.
All the best,
Mark