If you have enterprise manager you can use DTS as weirdan suggested. Otherwise, you will need a conversion kit of some sort. But I know that enterprise manager can DTS just about any RDBMS to just about any other DB format.
Who needs to have the tools - me or the SQL 2000 (my host) guys? My db is created and stored in SQL Server Express 2005 and it does not come with any tools of similar sort. Can the host import the data with DTS?
The only solution I know is connecting from my computer to the SQL 2000 server remotely and recreating the db there. What tool would allow me to do this? I can't find anything for this purpose.
I would google the term 'SQL Server Express DTS tool' or something along those lines. What you want is a Data Transformation Service application so you can talk to another DB from yours.
Well, I can connect to the MSSQL 2000 server from MS SQL Server Management Studio Express, and I can see and create tables (so basically I can view both db's side by side). Is there a way to copy-paste the tables from my db to the SQL 2000 db? Drag and drop doesn't work.
You mean scripting the SQL 2005 db? I let it generate the db object script and then executed it on an empty db in SQL 2000. There were some incompatibilities, but I corrected those manually (I think it was because of collation difference) and now I have the db table structure created. Is there an easy way to dump the data from the tables into txts so that I could send them to my host to import? I don't want to copy-paste table data of ~30 tables.
Damn, when I copy-paste the data manualy from SQL 2005 table to SQL 2000 table, my identities (primary/foreign keys) get messed up and the correct relationship is not maintained among tables. Any solutions on how to export all the data in my database and then import it back into my host's db so that identity relationships are not lost?