Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2005 > SQL Server 2005
SQL Server 2005 General discussion of SQL Server *2005* version only.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2005 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old April 15th, 2008, 12:18 PM
Authorized User
Join Date: Jun 2003
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Default Copying Tables From SQL Server 2005 to 2000

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 :)

Similar Threads
Thread Thread Starter Forum Replies Last Post
Conflict in SQL Server 2000 and SQL Server 2005 ayan.mukherjee SQL Language 0 June 30th, 2008 03:34 AM
Difference B/W sql server 2000 and 2005 bhasker_braj121 SQL Server 2005 1 January 19th, 2008 12:01 PM
mysql and sql server 2000/2005 Sheraz Khan MySQL 1 October 22nd, 2007 06:01 PM
migrating from sql server 2000 to sql server 2005 abinashpatra SQL Server 2005 2 December 1st, 2006 03:45 PM
SQL Server 2000 and 2005 ninel SQL Server 2005 4 September 14th, 2006 01:03 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.