Hi,
I am about to attach my SQL 2000 standard DBs to SQL2008 [if the
install ever finishes!] and realised how little information there is
on the 2000>>2008 path? Has anyone achived this yet and if so should I
be looking for anything out of the ordinary?

I simply want to take the 8 DBs form 2000 to 2008, what is the best
method to achieve this?

Thanx

G

Did you run the 2008 upgrade advisor against the 2000 instance before
detaching the databases? You might want to do that, it will find various
potential issues if they exist.

"gstar" gmail.com> wrote in message
news:cf3656d6-ac6e-476e-b203-4cbe46876236@k13g2000hse.googlegroups.com...

On Aug 8, 4:47 pm, "Aaron Bertrand [SQL Server MVP]"
wrote:

Hi,
All seems OK with that to be fair, my problems lie in the code which
attempts to connect asp to the database. I can connect through ODBC
and can telnet into teh server no problem, but our old code used
currenty in asp to connect to 2000 doesnt work and there seesm to be
absolutely no information anon this subject. Im fearful!!

<%%
set conn = server.createobject("adodb.connection")
conn.Open "provider=SQLOLEDB;user
id=myuser;password=mypassword;PersistSecurity Info=False;initial
catalog=dbname;Data Source=sqlserver2008"
%%>

Any offers?

Data Source should be the name of the server. Is the server named
SQLServer2008? Or is that the instance name? If it is a default instance,
this should be

Data Source=

If it is a named instance, this should be

Data Source=\sqlserver2008

A

On Aug 12, 3:13 pm, "Aaron Bertrand [SQL Server MVP]"
wrote:

OK, well maybe you could help us out a bit here. What does "doesn't work"
mean? Do you get an error? If so, what is it, and how long does it take to
be raised?

Hi Aaron,
Yes the information I posted is correct, sqlserver2008 is the name of
our server for this example. The strange thing is I can connect to
this server using ODBC with exactly the same data source. I am told
that with SQL Server 2008 the connection strings have changed but I
simply cannot track any information down. If you look at this site
http://www.connectionstrings.com/ it does suggest there are
differences between 2000/2005 but no info on 2008? Oddly the original
code does work with 2005 also?

Baffled?