Migrating MSDE to SQL Server 2000

[Tim Ferguson]

I've developed my shiny new ADP against my local copy of MSDE 1.0 and
it's all working. I've printed out the documentation and the hospital
bigwigs are happy to roll it out on their big black cube running SQL
Server 2000. My database is not huge: about

My only trouble now is how to get the database onto the server off MSDE
(this is at home where I'm not connected to the network):-

I could do a Backup/ Restore via a disk or email etc, but the
instructions say that the code pages and all sorts of environment have be
the same and that seems a lot to ask in such different settings. Am I
being over-pessimistic?

I don't have access to Enterprise manager or another tool that will
convert an existing database into a full SQL-DDL script. Is there one
that I can use for a one-off conversion (i.e. I can't justify a large
cost)?

I could go back to the documentation and hand-write the SQL-DDL but it
would obviously be prone to errors and omissions. This is my least
favoured solution but I have a feeling that it's going to come down to
this.

Any different ideas? This is starting to look worse than the requirements
analysis!

Thanks in advance


Tim F

 

[Alex]

Hi Tim,

you could test this,

write a script that detaches the database from msde sp_detach (should
be right spelling), copy both the mdf and the ldf to a cdrom, take the
cdrom to the hospital, copy to the server, take off the read only
attributes off the files, then run sp_attach to attach to new SQL
server. Doing it this way should work, test and see if it works.

Hope it works for you, I have done this many times, yes I take your
point about the code pages, etc but worth trying could save you loads
of time.

Regards

Alex

 

[Tim Ferguson]

write a script that detaches the database from msde sp_detach (should
be right spelling), copy both the mdf and the ldf to a cdrom, take the
cdrom to the hospital, copy to the server, take off the read only
attributes off the files, then run sp_attach to attach to new SQL
server. Doing it this way should work, test and see if it works.

Wow: that was fast! Thanks, I'll give it a go.

All the best


Tim F