Link to home
Create AccountLog in
Avatar of sdwirang
sdwirang

asked on

power shell script

Hi experts,

I would like to copy tables from one sql database server to another.Before copy i would like to truncate table and then copy the table,Could you please tell me the Powershell script version1.As i don't have poershell version2 instal;led in my xp machine.
Thaanks in advanace.
ASKER CERTIFIED SOLUTION
Avatar of Barry Cunney
Barry Cunney
Flag of Ireland image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Qlemo
Do you want to truncate the source table, or only copy the table structure?
Which MSSQL version are on source and destination?
Avatar of sdwirang
sdwirang

ASKER

nice