Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Newbie Question Expand / Collapse
Author
Message
Posted Wednesday, February 25, 2004 2:58 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 3, 2013 1:07 PM
Points: 9, Visits: 3

Sorry for this newbie question, but what is the best way to push out data from a development server to a production server. I have specific tables in a DB that I want to push out to the production server while keep the identity fields intact.  Any links or suggestions would be appreciated.  I'm looking for best/standard pratices so I can stop doing it the wrong way...

Thanks!




Post #102411
Posted Wednesday, February 25, 2004 5:08 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, October 28, 2004 8:04 AM
Points: 305, Visits: 1
DTS would probably be simplest.


------------

Ray Higdon MCSE, MCDBA, CCNA
Post #102445
Posted Wednesday, February 25, 2004 9:25 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 2:27 PM
Points: 33,267, Visits: 15,434
DTS is probably the simplest if it's a few tables and you are doing it rarely. Be sure you check the "keep identity" box.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #102459
Posted Thursday, February 26, 2004 5:22 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Yesterday @ 9:16 AM
Points: 6,784, Visits: 1,895
I like SQL Data Compare from RedGate, think maybe ApexSQL has a tool that does it too (I know it compares schema, not sure about data). It scripts it over, nice because you can see what needs to be added, changed, deleted.

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #102836
Posted Saturday, February 28, 2004 2:28 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, August 13, 2013 1:18 AM
Points: 5,956, Visits: 285
Just want to add:
What about using the Import/Export Wizard?



--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/
Post #103179
Posted Sunday, May 19, 2013 9:11 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 23, 2014 6:49 AM
Points: 62, Visits: 326
1) DTS
2) SSIS
3) SSRS report with time subscription in excel format.
Post #1454339
Posted Sunday, May 19, 2013 9:21 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 2:50 PM
Points: 1,920, Visits: 19,334
you seem to be making several postings to very old threads......????

______________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
Post #1454341
Posted Sunday, May 19, 2013 10:01 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:25 PM
Points: 43,008, Visits: 36,164
Please note: 9 year old thread. Also, neither SSIS nor SSRS exist in SQL 2000, they're in 2005 and onwards


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1454346
Posted Monday, May 20, 2013 8:37 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 3, 2013 1:07 PM
Points: 9, Visits: 3
Wow, this is a blast from the past! I posted this 9 years ago when I first started my job. Just to let everyone know, I figured it out, so thanks


Post #1454565
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse