Transfer SQL Server 2008 Database and Data to SQL Server 2005

 
11/08/2009 This works !! 
 
 
Also
 
 
SSMS > Select database > Right Click > Tasks > Generate Scripts > Proceed to "Choose Script Options" 
> Under "General" change option for Script for Server Version to SQL Server 2005 or 2000
> Can not see this but "If you are putting the database on a new instance for the first time, make sure the "Script Database Create" option is set to "True.""
> under "Table/View Options" select Script Data to True
> Proceed through rest of options choosing your preferences.
 
 
 
 
 
 
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: