Hello everyone,

Does anyone know of an easy way to copy tables from SQL Server 2005 to SQL Server 2000?

This apparently is not such an easy thing.

Here's what I want to do:

Copy all fields, indexes, constraints and keys from my SQL Server 2005, to a remote SQL Server 2000 environment.

But the only "Task" available to me is "Export Data", which does a nice job of creating simple tables with data in them, but with none of the keys, constraints, etc. that were set up originally.

I tried to Generate Scripts, and even just use "CREATE TABLE" scripts that I scripted to the window, but every time a constraint is in my script, SQL Server yells at me and says the syntax is broken. And it's not broken. I think it just likes to yell at me.

I am reduced to writing down all the keys, constraints and indexes I have, and manually setting them up after simple tables are created.

There's gotta be a better way ... right???

Hope someone can help,

Frustrated Susan in NYC

__________________
Susan :)