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
 General SQL Server Forums
 New to SQL Server Administration
 SQL 2005 data exported to New SQL 2008 database?

Author  Topic 

ostinoh
Yak Posting Veteran

66 Posts

Posted - 2011-09-19 : 13:27:21
Hello -

We currently have a SQL 2005 database environment and are looking to export some data off and onto another db server that would be SQL 2008. They would be custom scripts that would pull the data and insert it into the new db.

My question is can I use SQL 2008 for the new server and database even if the data is coming from a SQL 2005 server?

Regards,
David

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-09-19 : 13:34:24
yep. no problem with that. I assume scripts will be written on SQL 2008 box using linked server connection created to SQL 2005 to pull required data as per yur logic.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -