Erland, when you say "Import/Export options", are you referring to the
"Import and Export Wizard"? My problem with that is that it only
transfers data, not other objects.
OK, I have not looked into these very deeply.
Another option is Generate Scripts to get the objects. Here you can
select what to script.
Personally, I prefer to keep all code under source control and build
all databases from the version-control system, so I rarely have use for
scripting and the Copy Database Wizard myself.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Re: Max query size in osql or management studio? ... either the scripts or how people run them. ...SQLCMD has a few more features, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...Books Online for SQL Server 2005 at ... (microsoft.public.sqlserver.tools)
Re: Track changes made to SQL Server ... Develop scripts and keep them under source control. ...Books Online forSQLServer2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books ... ... As can xSQL Object from xSQL Software ... free for SQL Server Express and also free for other editions of SQL ... (comp.databases.ms-sqlserver)
Re: Check if a Table is used in any sp or function ... I can generate all the scripts and look for it. ... on a chunk border.... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...Books Online for SQL Server 2005 at ... (comp.databases.ms-sqlserver)
Re: What is Your Strategy for Upgrade an Access db to SQL Server 2000? ... use the wizard", did key word search for it to no avail. ... for both Access and SQL Server, ...Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...Books Online for SQL Server 2005 at ... (comp.databases.ms-sqlserver)
