sql server new users: 2000 import of 2005 data -- sql server new users

You're in the

sql server new users

group:

2000 import of 2005 data

MKerr
11/21/2006 1:47:47 PM

sql server new users:

I'm new to SQL 2005 and am wondering if there is anyway to export/script a
2005 database (including the data) into a file, then import that file into
SQL 2000. I've tried using the script option in Object Explorer, but I
don't seem to get the data into the script file with it. Thank you for any
help.

Re: 2000 import of 2005 data

Hari Prasad
11/21/2006 10:03:28 PM

Hi,

Please use the SQL Server Intergration services to copy the object and data
to SQL 2000 database.

Thanks
Hari

[quoted text, click to view]

Re: 2000 import of 2005 data

MKerr
11/22/2006 12:04:12 PM

Thank you for the response. I will research the methodology and see if I
can use Integration Services to output the results to a file readable by
2000. The computers are on seperate networks.

[quoted text, click to view]

Re: 2000 import of 2005 data

Arnie Rowland
11/24/2006 10:06:44 AM

These resources may help:

Generate Data Scripts
http://www.sqlscripter.com

Generate SQL (DDL) Scripts
http://www.karaszi.com/SQLServer/info_generate_script.asp

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server new users group.

home · blog · groups

Questions? Comments? Contact the dn