December 8, 2011 at 10:02 pm
Is Microsoft sql server 2012 launched????/
is it better to use .. currently i am using SQL 2005...
where could i get the installation material.
Thanks & Regards,
Pallavi
December 8, 2011 at 10:12 pm
RTM hasnt been released yet, but you can download RC0 to play with in the meanwhile:
http://www.microsoft.com/download/en/details.aspx?id=28145
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 8, 2011 at 10:33 pm
There are many improvements in SQL 2012. It will be out early 2012.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 8, 2011 at 10:44 pm
watch out for BI semantic model in SSAS 🙂
Raunak J
December 8, 2011 at 10:50 pm
pallavi.unde (12/8/2011)
Is Microsoft sql server 2012 launched????/is it better to use .. currently i am using SQL 2005...
where could i get the installation material.
It is not released yet. It will be released in first half of 2012. SQL Server has got few very good improvments such as AlwaysOn feature.
December 8, 2011 at 11:17 pm
Okiesss...
If i take a back up of database from SQL Server 2008 and trying to restore it in MSSQL 2005 then it shows error that it is not compatible.
How could we overcome this problem???
Thanks & Regards,
Pallavi
December 8, 2011 at 11:20 pm
You can't restore a 2008 database on SQL 2005.
If you must get the data from one to the other, you will need to import it (dts, ssis, redgate data compare).
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 9, 2011 at 12:46 am
pallavi.unde (12/8/2011)
Okiesss...If i take a back up of database from SQL Server 2008 and trying to restore it in MSSQL 2005 then it shows error that it is not compatible.
How could we overcome this problem???
As SQLRNNR said, you can't restore SQL Server 2008 database's backup to SQL Server 2005. You can upgreade a database from lower version to higher version but you can't downgrade a database from higher version to lower version.
December 9, 2011 at 12:51 am
Divine Flame (12/9/2011)
pallavi.unde (12/8/2011)
Okiesss...If i take a back up of database from SQL Server 2008 and trying to restore it in MSSQL 2005 then it shows error that it is not compatible.
How could we overcome this problem???
As SQLRNNR said, you can't restore SQL Server 2008 database's backup to SQL Server 2005. You can upgreade a database from lower version to higher version but you can't downgrade a database from higher version to lower version.
Can't??? :w00t: Export - Import, SSIS.
But I agree with Sujit & Jason. You shouldn't go back (downgrade) unless absolutely required.
December 9, 2011 at 1:03 am
Can't??? Export - Import, SSIS.
When I said "Can't" it means that there is no restore/detach-atach kind of readymade facility available for it :-).
You can always generate script for tables, procedures, views, functions & run them on the other server, then import-export the data if it is necessary to downgrade the database for some reason.
December 9, 2011 at 2:03 am
Ok thank you 🙂
Thanks & Regards,
Pallavi
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply