[VIEWED 2143
TIMES]
|
SAVE! for ease of future access.
|
|
|
xbox
Please log in to subscribe to xbox's postings.
Posted on 06-28-07 2:59
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
can somebody tell me how to move tables from Dev to Prod Environment. thanks in advance
|
|
|
|
xbox
Please log in to subscribe to xbox's postings.
Posted on 06-28-07 2:59
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
by the way i am in SQL server 2000
|
|
|
MillionDollars
Please log in to subscribe to MillionDollars's postings.
Posted on 06-28-07 3:10
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
Why don't you use a dts package ?
|
|
|
xbox
Please log in to subscribe to xbox's postings.
Posted on 06-28-07 3:22
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
how bout migrating store procs.
|
|
|
xbox
Please log in to subscribe to xbox's postings.
Posted on 06-28-07 3:25
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
is there any way to do it without recreating it in Prod environment
|
|
|
MillionDollars
Please log in to subscribe to MillionDollars's postings.
Posted on 06-28-07 3:30
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
If you want to recreate everything, why don't you take a DB back up and then restore in prod.
|
|
|
xbox
Please log in to subscribe to xbox's postings.
Posted on 06-28-07 3:34
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
no i dont want to recreate it, i have do it without recreating it and when u do dts, it will load data too. i dont want that either. just table structure and some store procs. thanks milliondollars
|
|
|
micky_mouse
Please log in to subscribe to micky_mouse's postings.
Posted on 06-28-07 3:44
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
Create the scripts of tables and stored procedures if you want to just create table and stored procedures. It is very simple stuff.
|
|
|
xbox
Please log in to subscribe to xbox's postings.
Posted on 06-28-07 3:47
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
|
|
|
fewatal
Please log in to subscribe to fewatal's postings.
Posted on 06-28-07 4:27
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
Xbox, i would do what Micky Mike suggested. It is prestty straight Forward. Hey Xbox and Micky Mouse, are you guys SQL Server DBA? I am curious as i am also a SQL Server DBA(just started)...i think you guys might be able to help me out when i run into issues. Please let me know. Thanks
|
|
|
xbox
Please log in to subscribe to xbox's postings.
Posted on 06-29-07 10:47
AM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
|
|
|
micky_mouse
Please log in to subscribe to micky_mouse's postings.
Posted on 06-29-07 11:31
AM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
Yes I do lot of database stuff in SQL 2000 and 2005. Thats good idea we can exchange our knowledge for our best.
|
|
|
fewatal
Please log in to subscribe to fewatal's postings.
Posted on 06-29-07 11:45
AM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
Hi Xbox and Micky, Thank you for your response . i sent you email. Please check that and then send me response back with your email so that i can write u sometimes and share the stuff. I am kind a new in SQL server so i have hope that you guys wil help me ....i am a baby in SQL server but i love to work ..it is great I look forward to hearing from you Thanks a bunch! Fewatal
|
|