Copying Tables From SQL Server 2005 to 2000
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