Hi,
I have data in an old database I would like to capture for my newsystem but I dont have the original insert scripts. Is there atool (in SQL Server 2000 or thirdparty) that will help me export thedata as SQL inserts?
Thanks
jr.
Use DTS. Are they both SQL Server databases? If so, you canimport data from one database to another. Use the Import Datawizard. If the old database is not SQL Server, export the file toCSV, and the use SQL Server's Import Data wizard to import from the CSVfile.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment